Formula problem

[GVegas]

I have the following formula to calculate a persons age based on todays date
in one column and their DOB in another, but I need to modify the formula so
if no DOB is listed, the formula returns a blank. Currently a blank in the
DOB column calculates to 108.

=DATEDIF(M2,K2,"Y")
I need to add something to this so I get a blank, not 108.

HELP!!!

Thanks

 

[Teethless mama]

=IF(M2="","",DATEDIF(M2,K2,"Y"))

 

[Bob Phillips]

=IF(OR(M2="",K2=""),"",DATEDIF(M2,K2,"Y"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)