Default to beginning of month
 

In cell A10 is a date (e.g. 8/23/2005), I need the next cell to always
default to the beginning the of month that correspondes to the date in cell
A10. (e.g. 8/01/2005)
How do you do this?????

Thanks in advance.
--
Heather

Hi!

=DATE(YEAR(A10),MONTH(A10),1)

Biff

"Heather" wrote in message
...
In cell A10 is a date (e.g. 8/23/2005), I need the next cell to always
default to the beginning the of month that correspondes to the date in
cell
A10. (e.g. 8/01/2005)
How do you do this?????

Thanks in advance.
--
Heather

=A2-DAY(A2)+1

--

HTH

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


"Heather" wrote in message
...
In cell A10 is a date (e.g. 8/23/2005), I need the next cell to always
default to the beginning the of month that correspondes to the date in
cell
A10. (e.g. 8/01/2005)
How do you do this?????

Thanks in advance.
--
Heather

IT WORKS!!!!

THANKS TO EVERYONE WHO HELPED!!

HEATHER

"Biff" wrote:

Hi!

=DATE(YEAR(A10),MONTH(A10),1)

Biff

"Heather" wrote in message
...
In cell A10 is a date (e.g. 8/23/2005), I need the next cell to always
default to the beginning the of month that correspondes to the date in
cell
A10. (e.g. 8/01/2005)
How do you do this?????

Thanks in advance.
--
Heather

THIS ONE WORKS TOO!

YA'LL SAVED THE DAY!

THANKS AGAIN!

HEATHER

"Bob Phillips" wrote:

=A2-DAY(A2)+1

--

HTH

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


"Heather" wrote in message
...
In cell A10 is a date (e.g. 8/23/2005), I need the next cell to always
default to the beginning the of month that correspondes to the date in
cell
A10. (e.g. 8/01/2005)
How do you do this?????

Thanks in advance.
--
Heather