Date Question

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

Guest

Greetings and TIA for your hel
Please suggest a formula to return a date that is 10 years ago from today
Thanks again
 
=DATE(YEAR(TODAY())-10,MONTH(TODAY()),DAY(TODAY()))

or with the Analysis Toolpak add-in activated...

=EDATE(TODAY(),-10*12)
 
Back
Top