Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an age from 2 dates
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! -- Terri |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an age from 2 dates
Chip Pearson has some very nice notes:
http://www.cpearson.com/excel/datedif.aspx Terri wrote: 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! -- Terri -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an age from 2 dates
Try this
=INT((birthdate - visit date)/365.25) Put this into cell C1 =INT((A1-B1)/365.25) "Terri" wrote: 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! -- Terri |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an age from 2 dates
Sorry try this instead of my last post
=INT((visit date - birthdate)/365.25) Put this into cell C1 =INT((B1-A1)/365.25) "Mike" wrote: Try this =INT((birthdate - visit date)/365.25) Put this into cell C1 =INT((A1-B1)/365.25) "Terri" wrote: 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! -- Terri |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating an age from 2 dates
Birthdate in A1 and Visit date in A2...
=DATEDIF(A1, A2,"y")&" years "&DATEDIF(A1,A2,"ym")&" months "&DATEDIF(A1,A2,"md")&" days" -- HTH... Jim Thomlinson "Terri" wrote: 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! -- Terri |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating between 2 given dates | Excel Discussion (Misc queries) | |||
calculating dates | New Users to Excel | |||
calculating due dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
calculating with dates | Excel Discussion (Misc queries) |