Date 3 years ago in excel

May 4, 2009 at 13:02:57
Specs: Windows XP
Ok I have tried to search on here and on Google to no end to find a solution to my problem. I need to display the date exactly 3 years ago. Here is what I have tried:


It gives me a date 3 years ago but it doesn't take in effect leap years. If anyone could point me in the correct direction I would be very appreciative.

See More: Date 3 years ago in excel

Report •

May 4, 2009 at 17:25:44
Here's two different ways to the same end, both for 3 years.

Make cell A1 your date cell then in cell B1 enter:





Report •

May 5, 2009 at 12:11:50
Thanks that worked like a charm.

Report •

May 5, 2009 at 13:23:57
Your welcome, Glad I could help.


Report •

Related Solutions

Ask Question