Creating formula to calculate future dates...

  • Thread starter Thread starter wikked21
  • Start date Start date
W

wikked21

I am trying to find information on creating a forumla in
Excel to calculate future dates from a certain starting
point.

For example, if I have a column (lets call it D) with a
specific date I would like to create a forumla that will
produce future dates in columns E, F, and G for a specific
time interval.

The example would be this: Cell D2 has the date 01/01/03
and that would be the starting reference date. I would
like a formula in columns E2, F2, and G2 that would show
the dates as E2=01/01/03 + 60 days, F2=E2 + 60 days,
G2=F2+60 days.

Is this possible? Any help or insight would be greatly
appreciated.
 
Hi

Presuming your 'starting date' is a proper Excel date, you can just use
these:
In E2 =D2+60
In F2 =E2+60
In G2 = F2+60

Andy.
 
Back
Top