Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Sep 12, 2024
Solved

I have a formula for calculate age from birthday date

I have a formula for calculating age from birthday date.   =DATEDIF(B2,TODAY(),"Y") I do not have all birthday dates It put 124. I want it empty. How I do that   Thanks You.
excel
Formulas and Functions
  • Rodrigo_'s avatar
    Rodrigo_
    Sep 12, 2024
    use this: =IF(ISBLANK(B2), "", DATEDIF(B2, TODAY(), "Y"))
Rodrigo_'s avatar
Rodrigo_
Iron Contributor
Sep 12, 2024
use this: =IF(ISBLANK(B2), "", DATEDIF(B2, TODAY(), "Y"))

Resources