| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date arithmetic: adding 1 month to prior end of month date
I'm using the =DATE(YEAR(B32),MONTH(B32)+1,DAY(B32)) where B32 is the prior
date. This works fine when the prior month's day is not the last day of the month. If it is the last day, the results are a little goofy. For example, adding one month to 6/30/06 produces 7/30/06 instead of 7/31/06. Adding one month to 1/31/06produces 3/3/06 instead of 2/28/06. Is there a way to add whole months to prior months when the prior month's day is the last day of the month? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding specific cells based on a corresponding date | Excel Worksheet Functions | |||
| Formula = Today's date + 1 month | Excel Worksheet Functions | |||
| Get month from date | Excel Discussion (Misc queries) | |||
| Pulling a date in the current month | Excel Worksheet Functions | |||
| Return the end of month date from a date | Excel Worksheet Functions | |||
Threaded Mode
