Forum Discussion
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.
- use this: =IF(ISBLANK(B2), "", DATEDIF(B2, TODAY(), "Y"))
1 Reply
- use this: =IF(ISBLANK(B2), "", DATEDIF(B2, TODAY(), "Y"))