| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
I think this should do it:
B1: =EOMONTH(A1,-1)+1 Regards, Ron |
|
#3
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract date from the most current date | Excel Discussion (Misc queries) | |||
| Date Math Problem | Excel Worksheet Functions | |||
| date and time | New Users to Excel | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
