Calculate age v2

T

Terrie

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

Thanks
terrie
 
P

Peo Sjoblom

Please post follow ups in the same thread

=DATEDIF(C1,DATE(2004,1,1),"y")

and

=DATEDIF(C1,DATE(2004,1,1),"ym")

change DATE(2004,1,1) to DATE(2004,7,1)

for July
 
Top