In Excel, I need a date math formula...

Lisa · Dec 2, 2004

I need to create a forula that uses a date in a cell and adds five years to
that date and returns that answer.

Can this be done?

Thanks,

Lisa

Norman Jones · Dec 3, 2004

Hi Lisa,

Try:

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

Peo Sjoblom · Dec 3, 2004

=DATE(YEAR(cell)+5,MONTH(cell),DAY(cell))

Regards,

Peo Sjobom