Forum Discussion

Copper Contributor

Oct 03, 2018

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.

excel

Formulas and Functions

SergeiBaklan
Oct 03, 2018
Hi Richard,

Please check this https://exceljet.net/formula/get-age-from-birthday

SergeiBaklan

Diamond Contributor

Sep 14, 2021

BBacon621

That could be

=DATEDIF( DOB, TODAY(), "m")

BBacon621

Copper Contributor

Sep 14, 2021

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

HansVogelaar
MVP
Sep 14, 2021
BBacon621

=DATEDIF(DOB,TODAY(),"y")&" year(s), "&MOD(DATEDIF(DOB,TODAY(),"m"),12)&" month(s)"
- BBacon621
  Copper Contributor
  Sep 14, 2021
  OK - THANKS - I figured out my mistake - it works now..... THANK YOU!
- BBacon621
  Copper Contributor
  Sep 14, 2021
  I get the dreaded #NAME? 😞
  - BP_Russell
    Copper Contributor
    Mar 19, 2022
    BBacon621
    
    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