Oct 03 2018 08:22 AM
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.
Oct 03 2018 09:11 AM
SolutionOct 03 2018 09:56 AM
Hi Richard,
You can use the DATEDIF function as follows:
=DATEDIF(A1,TODAY(),"Y")
Where cell A1 is the birthdate.
Hope that helps
Dec 12 2020 05:16 AM
Dec 12 2020 05:22 AM
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
Jul 22 2021 06:08 AM
Jul 22 2021 06:18 AM
Could you share screenshot or sample file, and what exactly means "not work"?
Jul 23 2021 06:33 AM
@Sergei Baklan 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
Jul 23 2021 08:06 AM
As variant birthdays are entered as texts which looks as dates, not as values which Excel recognize as dates for your regional settings. Whatever. Why don't you share small sample file?
Aug 29 2021 05:11 AM
Aug 29 2021 05:52 AM
Function is not mentioned in fx list and if you type it in the cell you see no prompt till first bracket. After that also not very informative, but at least something
Sep 14 2021 12:15 PM
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?
Sep 14 2021 01:10 PM
Sep 14 2021 01:14 PM
=DATEDIF(DOB,TODAY(),"y")&" year(s), "&MOD(DATEDIF(DOB,TODAY(),"m"),12)&" month(s)"
Sep 14 2021 01:24 PM
Mar 19 2022 10:05 AM
I have also encountered the ?NAME error. When I type in the formula, it prompts me for the correct info; but I cannot get it to return results. Has anyone found a solution for this?
Thanks
--B
Oct 03 2018 09:11 AM
Solution