| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Getting a date six months back
I want to be able to enter a date in cell A1, and have cell B1 be the last
day of the month, six months earlier So if I enter 7/18/2005, the date in B1 would be 1/31/2005. 8/3/05 would 2/28/05 (and would adjust if this were a leap year). Can someone help me with this formula? Thanks very much. Daniel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
| Convert date to length of time in months from set date | Excel Worksheet Functions | |||
| Return a date 6 months from a date in another cell | Excel Worksheet Functions | |||
| Roll back to previous date | Excel Worksheet Functions | |||
Threaded Mode
