Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need a formula that will return the last day of the month for a period of
two months prior to the date I enter. For example, if I enter 1/1/08 in Cell A1, I want Cell B1 to return 11/30/07; if I enter 2/1/08 in Cell A1, I want Cell B1 to return 12/31/07, etc.. P.S. Cell A1 will always be the first day of the month (if that matters) Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Calculation | Excel Worksheet Functions | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Date Calculation | Excel Discussion (Misc queries) | |||
Date calculation | New Users to Excel | |||
Date calculation | Excel Worksheet Functions |