Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need a formula to be able to add months to a date,
Example: If my date is 1/1/00 I want to add 18 (30,42,54, etc) months to it, and calculate to 7/1/01 (7/1/02, 7/1/03,7/1/04, etc). I can get it to come out using number of days but because of leap years some of the calculations come out to 6/30 rather than 7/1. We use Office 03. Please help me! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding 6 Months to a Date | Excel Worksheet Functions | |||
My discovery on adding months and days to a date! | Excel Worksheet Functions | |||
Adding 6 months to any given date | New Users to Excel | |||
adding months to an inputted date | Excel Discussion (Misc queries) | |||
Excel Adding years or months to a date | Excel Discussion (Misc queries) |