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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Hru48" wrote in
message ...

hey all,

I have worked out the first and last day of the month by using these
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 I
could do with, cell D1 is =b1&" - "&c1

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

Anyone got any ideas.

Cheers


--
Hru48
------------------------------------------------------------------------
Hru48's Profile:
http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=506733