Donna,


Your formula is incorrect for working out age and as an example put
=Today() in J1
31/12/2007 in C2

Your formula will tell you that person is 1 yr old which clearly someone
born on that day is only 4 months old.

Use datedif instead and to get around the 108 problem check the cells are
populated.

=IF(AND(C2<"",J1<""),DATEDIF(C2,$J$1,"y"),"")

Mike

"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