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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 02:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com