Help with date formulas in Excel

L

LLEW

I need to subtract 3 years from dates in a spreadsheet, i.e. 11/1/2005 minus
3 years. All of the help formulas show that you have to enter the month, day,
and year numbers into the formula for each date. I would like to use a
formula that allows me to use the date values in the cell references,
something like A1- three years.

Thank you!
 
B

Bob Phillips

=DATE(YEAR(A1)-3,MONTH(A1),DAY(A1))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top