Need 1 year and 2 year projection dates

[acohn]

I'm tracking when staff traings will be due in the future and need the formula for 1 year from a specific date and 2 years from a specific date - I would like the due date to appear when I type in the current training date.

thanks for your assistance
Abby

 

[T. Valko]

I'm tracking when staff traings will be due in the future and need the formula for 1 year from a specific date and 2 years from a specific date - I would like the due date to appear when I type in the current training date.

thanks for your assistance
Abby

Try these...

A1 = some date

For 1 year:

=EDATE(A1,12)

For 2 years:

=EDATE(A1,24)

Format as Date

Note that the EDATE function requires the Analysis ToolPak
add-in be installed if you're using a version of Excel prior to
Excel 2007. If you enter the formula and get a #NAME?
error look in Excel help for the EDATE function. It'll tell you
how to fix the problem.

 

[Gerald Higgins]

Or if you don't want to use the Tool Pak

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

 

[T. Valko]

Or if you don't want to use the Tool Pak

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

If the date in A1 just happens to be a leap day then what date should be returned for the next year?

The EDATE and DATE formulas return different results.

If A1 = 2/29/2008 there is no 2/29/2009. The EDATE formula will return 2/28/2009 and the DATE formula will return 3/1/2009.