Formula problem

G

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
 
B

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)
 
Top