Formula problem
=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
|