I got it worked out.

=NPV(PV_Liab_Rate,INDIRECT("R"&RowRetYrStart&"C5:R "&RowRetYrEnd&"C5",FALSE))*(1+PV_Liab_Rate)

Thanls for your help.

"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.