Using Excel to calculate future dates with various intervals
Let's assume your start date is 2/29/2008 and you want the future date in 12
months (1 year). What result do you expext?
Start date is 1/31/2009 and you want the future date in 1 month. What result
do you expect?
The future dates for the weeks is pretty straightforward:
1 week: =start_date+7
2 weeks: =start_date+14
For the months and years, well, you have to think about those for a minute
and decide what the correct end date should be because months and years
don't have the same number of days in them!
--
Biff
Microsoft Excel MVP
"MH" wrote in message
...
Hi,
I need to build a calendar, where I have a given start date. From this
start date, I need to capture future predicted dates, based on various
intervals. How do I do this?
Example:
Start Date: 1/1/09
Future Date intervals: 1 week, 2 weeks, 1 month, 3 months, 12 months, 18
months, 2 years
Thanks for your help with this.
MH
|