Date Defaulting
 

I have a date in cell A1 (e.g. 08/24/2005) and I would like cell B1 to
automatic default to the beginning of whatever month is in the prior cell,
A1. (e.g. 08/01/2005). Is there a formula to do this? HELP!

Thanks in advance.
--
Heather

I think this should do it:
B1: =EOMONTH(A1,-1)+1

Regards,
Ron

=A1-DAY(A1)+1

--

HTH

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


"Heather" wrote in message
...
I have a date in cell A1 (e.g. 08/24/2005) and I would like cell B1 to
automatic default to the beginning of whatever month is in the prior cell,
A1. (e.g. 08/01/2005). Is there a formula to do this? HELP!

Thanks in advance.
--
Heather