Calculate age

  • Thread starter Thread starter Terrie
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate age v2 1
Calculate age 3
Exclude blank data from formula calculation 3
Calculate age 3
How do I calculate a persons age from birth dates 1
How do I calculate a person's age from date of birth and a date 2
Calculating When Somebody Reaches a Certain Age 4
date of birth age formula 8

Back
Top