Calculate age

T

Terrie

If I have the date of birth in column C, what would the
formula be to calculate their age at the first of january
(Or first of July)this year?

Thanks
terrie
 
J

JMay

With date of birth in C1 say 4/15/44
C4 = 1/01/04
=DATEDIF(C$1,C4,"y") = 59
C5 = 7/01/04
=DATEDIF(C$1,C5,"y") = 60
HTH
 
Top