| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date formula
I want to add 12 months to a start date (inclusive of the start date) and
return the end date. Start date will only be the first or last day of the month. Calculated end date must only return the first or last day of the month. Eg: Start 06/30/2009 Add 12 months Result should = 05/31/2010 Eg: Start 06/01/2009 Add 12 months Result should = 05/01/2009 Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Threaded Mode
