Articles

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:

=today()-1095

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 •


#1
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:

=A1-((365.25*3)-1)

or

=MONTH(A1)&"/"&DAY(A1)&"/"&(YEAR(A1)-3)

MIKE

http://www.skeptic.com/


Report •

#2
May 5, 2009 at 12:11:50

Thanks that worked like a charm.

Report •

#3
May 5, 2009 at 13:23:57

Your welcome, Glad I could help.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question