If "dtBirthday" is not a valid date , then #VALUE! is returned.Alternatively you could use the following formula: =INT(YEARFRAC(TODAY(),"01/07/1977",1))Alternatively you could use the following formula: =DATEDIF(DATE(1977,7,1),NOW(),"y")