Calculate age v2

  • 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 inyears and months at
the first of january (or first of July)this year?

Thanks
terrie
 
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
 

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 2
Calculate age 3
Exclude blank data from formula calculation 3
How do I calculate a persons age from birth dates 1
Calculate age 3
date of birth age formula 8
Calculating When Somebody Reaches a Certain Age 4
How do I calculate a person's age from date of birth and a date 2

Back
Top