Forum Discussion
Age calculation
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
Do you have a formula that would calculate age in months? i.e. infants for a daycare spreadsheet based on DOB and today's date?
- thank you - it "sorta worked" I wanted the formula to show me in one cell for example:
18 months should show as 1 year, 6 months (if it's possible)
thanks
Could you share screenshot or sample file, and what exactly means "not work"?
SergeiBaklan I had existing data ranges filled out with birth dates in them. I wanted the year first and tried formatting this way but the changes never occurred. After giving up on that I still wanted to figure out current age and since I will be looking at this file for years to come I would like it to update automatically. What function do I use to do this? Thanks
- This is fine, but only when the date is after 1904
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
Thanks!
