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

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


"GVegas" wrote:

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

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

"GVegas" wrote in message
...
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