Calculate age

[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

 

[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

 

[Dan Chupinsky]

You may want to read more about this sometimes hidden function at Chip
Pearson's
site:

http://www.cpearson.com/excel/datedif.htm