Calculating an age from 2 dates

T

Terri

I am trying to calculate someone's age on a date that is after their
birthday. I know how to do the calculation if I am going from a later date
to an earlier date but how do I go from an earlier date to a later date? for
example,
birthdate visit date
1 12/25/72 8/28/2007

Is there a calculation that can show how old the person was on the visit date?

Thank you!
 
M

Mike

Try this
=INT((birthdate - visit date)/365.25)

Put this into cell C1
=INT((A1-B1)/365.25)
 
M

Mike

Sorry try this instead of my last post
=INT((visit date - birthdate)/365.25)

Put this into cell C1
=INT((B1-A1)/365.25)
 
J

Jim Thomlinson

Birthdate in A1 and Visit date in A2...

=DATEDIF(A1, A2,"y")&" years "&DATEDIF(A1,A2,"ym")&" months
"&DATEDIF(A1,A2,"md")&" days"
 

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

date of birth age formula 8
Calculating an age at a certain date 4
Calculating age 6
calculating an age 6
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
How do I calculate a persons age from birth dates 1
How do I calculate a person's age given their birthdate and using. 1
Excel 2003 How do I determine an age of "?" using a set date as r 1

Top