Date Defaulting

H

Heather

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.
 
B

Bob Phillips

=A1-DAY(A1)+1

--

HTH

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