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