Forum Discussion
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.
26 Replies
I have the same issue. I tried your formula and it worked great unless the DOB cell is blank. Then is fills the AGE cell with 125 based on the year 1900 I'm assuming. I need a formula that will leave the DOB cell blank if there isn't a DOB. I hope you can help!!!
I have the same issue. I tried your formula and it worked great unless the DOB cell is blank. Then is fills the AGE cell with 125 based on the year 1900 I'm assuming. I need a formula that will leave the DOB cell blank if there isn't a DOB. I hope you can help!!!
Like this:
=IF(DOB="", "", DATEDIF(DOB,TODAY(),"y")&" year(s), "&MOD(DATEDIF(DOB,TODAY(),"m"),12)&" month(s)")
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?
Could you share screenshot or sample file, and what exactly means "not work"?
- 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
- Hi Sergei
My Excel doesn't have the datedif function on fx.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
Thanks! Works a treat!
