Hey all,

I need a cell to work to return the first and last day of the month it
is in without me having to type anything in. In the format mm/dd/yyyy -
mm/dd/yyyy

I was thinking I could use date(now) and then use date difference to
figure this out but i'm not too sure on the syntax.

Any help would be great.

Thanks.


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