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)
Thanks that worked like a charm.
