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

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

Hi Lisa,

Try:

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

---
Regards,
Norman



"Lisa" wrote in message
...
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

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


Regards,

Peo Sjobom

"Lisa" wrote:

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