View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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