Forum Discussion
Automatic age update in Excel 2016
I have an Excel spreadsheet that gives the football player's age in column C. On a given anniversary date, say August 1, I need the ages to increase by 1. Could you provide a formula for doing this please?
- Use
=IF(MONTH(TODAY()) > MONTH(A1) OR (MONTH(TODAY()) = MONTH(A1) AND DAY(TODAY()) >= DAY(A1)), YEAR(TODAY()) - YEAR(A1), YEAR(TODAY()) - YEAR(A1) - 1)
Where A1 = Birthdate
Feel free to ping me for further assistance.
