Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Date 3 years ago in excel

Comment:

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.

Name: Mike (by mmcconaghy)
Date: May 4, 2009 at 17:25:44 Pacific

Reply:

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/

0

Reply:

Thanks that worked like a charm.

0

Name: Mike (by mmcconaghy)
Date: May 5, 2009 at 13:23:57 Pacific

Reply:

Your welcome, Glad I could help. MIKE http://www.skeptic.com/

0

new asus netbook

Exchange password headach...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I have two different date where I want to know the no. of days, weeks, months and year. Is there any formula in Excel 2000 which can help me to solve this problem. Thanks ...

Summary: Ok I think I have it almost figured out. I can use a conditional formula to run the date. I found the following formula: =VALUE(LEFT(C1,2)&"/"&MID(C1,3,2)&"/"&RIGHT(C1,2)) That works for dates that ha...

Summary: I have tried using the 1 cell with a date filled in and placing that cell # into the formula you all are giving me. But its not turning my dates colors. Maybe im thinking this process wrong. The dat...