Forum Discussion
Solved
Age calculation
I have a list of dates of birth from a membership spreadsheet. Is there a formula to give me ages of members against current date? Thanks in advance.
This is fine, but only when the date is after 1904
what can we do then ?
what can we do then ?
In Excel dates start from Jan 01, 1900 (Windows) or 1904 (Mac). To work with earlier dates please check workarounds here
How to calculate ages before 1/1/1900 in Excel - Office | Microsoft Docs