determining past dates

April 18, 2009 at 11:00:42
Specs: Windows XP
I want to determine the exact date 1, 4 & 9 years ago in Excel 2000... any tips?

See More: determining past dates

Report •

April 18, 2009 at 12:47:17
Here's two different ways to the same end, both for 9 years.

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




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


Report •
Related Solutions

Ask Question