I don't know how to make it work as I am working with years as in the policy
years of a life insurance policy. So my starting point is somewere after the
first year and the end point is some "X" number of years after the starting
point.

"Spiky" wrote:

On Aug 26, 4:14 pm, Spiky wrote:
Try the EDATE function. If A1 is the beginning date and B1 is the
number of years.
=EDATE(A1,B1*12)

Forgot: you need the Analysis toolpak if not in Excel 2007.