Help with date formulas in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
=DATE(YEAR(A1)-3,MONTH(A1),DAY(A1))

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Average dates help 0
Workday Formula to include date 0
date function 10
Blanking cells with formulas 2
#NAME? Error 3
Current Month with real date 2
Location Oriented Formula 1
Excel Vba to change displayed year automatically. 14

Back
Top