Forum Discussion
Date of Birth
in a cell can 80 Y Be changed to actual date of birth like 9/20/1941
Fran_Cunicelli1645 Let's say you have the number 80 entered in A1, this formula will produce a date 80 years before today.
=EDATE(TODAY(),-A1*12)
You could replace TODAY() with the actual birth day in the current year. In your example that would be:
=EDATE(DATE(2022,9,21),-A1*12)