Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
=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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add one month to the previuos month | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions | |||
Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
UserForm to select current month or earlier | Excel Discussion (Misc queries) | |||
How to extract month number from month name | Excel Discussion (Misc queries) |