Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Windows 2000 > determining past dates

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

determining past dates

Reply to Message Icon

Name: hrcoordinator
Date: April 18, 2009 at 11:00:42 Pacific
OS: Windows XP
Subcategory: Software Problems
Comment:

I want to determine the exact date 1, 4 & 9 years ago in Excel 2000... any tips?



Sponsored Link
Ads by Google

Response Number 1
Name: Mike (by mmcconaghy)
Date: April 18, 2009 at 12:47:17 Pacific
Reply:

Here's two different ways to the same end, both for 9 years.

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

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

or

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

And just so you know, if you post your Excel questions in the 'Office Software' forum you'll get a better response.

MIKE

http://www.skeptic.com/


0
Reply to Message Icon

Related Posts

See More


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links
Ads by Google


Results for: determining past dates
DATE string for a directory in DOS www.computing.net/answers/windows-2000/date-string-for-a-directory-in-dos/36365.html

Batch file for current date www.computing.net/answers/windows-2000/batch-file-for-current-date/59489.html

Dttermine Reformat Date www.computing.net/answers/windows-2000/dttermine-reformat-date/55565.html