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.
Hi Richard,
You can use the https://support.office.com/en-us/article/DATEDIF-function-25dba1a4-2812-480b-84dd-8b32a451b35c function as follows:
=DATEDIF(A1,TODAY(),"Y")
Where cell A1 is the birthdate.
Hope that helps
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