How do I calculate a person's age on a specific date? (huge roster

G

Guest

I have a huge roster of children and want to caluclate each child's age (in
years and months) on the first day of school 09/01/2007.
For example, if a particular child's birthday is on 7/5/2004, her age in
years and months is " 3 yr. 2 mo's.)

How do I calculate a person's age on a specific date (09/01/2007)?
 
J

JE McGimpsey

One way:

A1: <birthdate>
B1: 09/01/2007
C1: =DATEDIF(A1,B1,"y") & " yr. " & DATEDIF(A1,B1,"ym") & " mo's."
 

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

Please help with formula (multiple ifs to determine due date) 3
How do I calculate a persn's age in years & months in Excel? 4
Birthday Calculations 1
How do I calculate a person's age from date of birth and a date 2
"how do I calculate age by using date of birth details" 5
How do I put in a formula in Exel to calculate a persons age? 11
How do I calculate age using dates in Excel? 2
How do I calculate an age from 2 dates? 3

Top