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

--

HTH

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


"LLEW" wrote in message
...
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!