Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Good morning,
I am working on a spreadsheet where I need to determine a future date based on a date I entered For Instance: - In A1, I enter Feb 2, 2006 - In A2 I would like to automatically determine the end date Feb 1, 2007 (12 months after) - In A3, I would like to automaticall determine another end date Feb 1, 2008 (24 months after) Is there a way to do so without having to care about the number of days in between 2 dates? I would like to avoid the very simple A2=A1+ 365days... Especially when the number of days vary from one year to the other (leap years) Thanks Michel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with a date calculation | Excel Discussion (Misc queries) | |||
Date Calculation to exclude weekends | Excel Worksheet Functions | |||
Calculation based with Range of Date | New Users to Excel | |||
search for latest date | Excel Worksheet Functions | |||
Due Date Calculation? | New Users to Excel |