date format

H

Hru48

hey all,

I have worked out the first and last day of the month by using thes
formulas

cell A1 is =NOW()
cell B1 is =DATE(YEAR(A1), MONTH(A1),1)
cell c1 is =DATE(YEAR(A1),MONTH(A1)+1,0)

and now I want the results of B1 and C1 in one cell which I thought
could do with, cell D1 is =b1&" - "&c1

but everytime I try this I loose the date format in D1 and I can't ge
it back.

Anyone got any ideas.

Cheer
 
B

Bob Phillips

=TEXT(B1,"dd/mm/yyyy")&" - "&TEXT(C1,"dd/mm/yyyy")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
K

Kevin B

Modify the data values to strings using this variant of your existing formula:

=Text(b1,"m/d/yyyy")&" - "&Text(c1,"m/d/yyyy")

If you want different date formats, you can use "dddd, mmmm d, yyyy",
"yy-mmm-dd", just to name a few...
 
Top