formula for the date 16 years ago.

[electric_d]

Hi, im having trouble for making a formula for the the date 16 years
ago. i understand the the formula for todays date is =TODAY() but im
not sure how to modify it.

thanx for your time

 

[Peo Sjoblom]

One way

=DATE(YEAR(TODAY())-16,MONTH(TODAY()),DAY(TODAY()))