Date Defaulting

[Guest]

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.

 

[Guest]

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

Regards,
Ron

 

[Bob Phillips]

=A1-DAY(A1)+1

--

HTH

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