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
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=DATEDIF(DOB,TODAY(),"y")&" year(s), "&MOD(DATEDIF(DOB,TODAY(),"m"),12)&" month(s)"
