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.

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

Thanks that worked like a charm.

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History