I have a formula for calculate age from birthday date

[sf49ers19238597]

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.

[#2 · Accepted solution]

use this: =IF(ISBLANK(B2), "", DATEDIF(B2, TODAY(), "Y"))