=IF(C2="","no record of birthdate",YEAR($J$1)-YEAR(C2))


Gord Dibben MS Excel MVP

On Mon, 14 Apr 2008 02:57:00 -0700, Donna
wrote:

I have a formula =YEAR($J$1)-YEAR(C2) calculating age from date of birth.

However some of my entries do not have an entry for date of birth, so their
'age' ends up as being (for example) 108.

Is there a way of making sure the formula does not calculate these ages?

Thanks