Help with date formula

[mwood6275]

I an using the following date formula which works fine. =DATEDIF(F5,TODAY(),"y")

It will return a persons age.

My problem is how do I get it to show nothing if F5 is blank?

[daddylonglegs]

You can add an IF function, e.g.

=IF(F5="","",DATEDIF(F5,TODAY(),"y"))

[mwood6275]

Worked perfectly. Thank you