Don't Show Age if DOB not Present

[.Justin]

I have a SS that works out ages of those in the SS. DOB is column F and Age if column G.

In column G i have the following formula

=DATEDIF(F11,TODAY(),"Y")

However if column F is empty it automatically puts 116 as the age. Is there a way to only enter the age if DOB is present?

 

[sneuberg]

Something like

=IF(ISBLANK(F11),"",DATEDIF(F11,TODAY(),"Y"))

would take care of the case where F11 is blank, but using Datedif to calculate age won't produce the right answer all of the time. Suggest checking out

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