Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to calculate a person's age taking into account their birthda.
I want to figure the age of a person based on two entered dates, their
birthday and another date of occurrance. I want this to reflect whether or not their birthday has yet occurred in this calendar year. |
#2
|
|||
|
|||
Hi
Chip Pearson's web page http://www.cpearson.com/excel/datedif.htm#Age has the following info: Calculating A Person's Age A frequent use of the DATEDIF is to compute someone's age based on the current date and their birthday. The formula below will return someone's exact age based on their birthday in cell A1. =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days" This will return a string like 33 years, 9 months, 18 days instead of NOW() (which uses the current date) you can put another cell reference in containing the date you want their age known at. Cheers JulieD "CPD174" wrote in message ... I want to figure the age of a person based on two entered dates, their birthday and another date of occurrance. I want this to reflect whether or not their birthday has yet occurred in this calendar year. |
#3
|
|||
|
|||
Use the DATEDIF function.
=DATEDIF(birthdate,TODAY(),"y"*) See www.cpearson.com/excel/datedif*.htm for more details about DATEDIF. -- HTH RP (remove nothere from the email address if mailing direct) "CPD174" wrote in message ... I want to figure the age of a person based on two entered dates, their birthday and another date of occurrance. I want this to reflect whether or not their birthday has yet occurred in this calendar year. |
#4
|
|||
|
|||
Thank you - a great help! Vanessa Leonard
"Bob Phillips" wrote: Use the DATEDIF function. =DATEDIF(birthdate,TODAY(),"y"Â*) See www.cpearson.com/excel/datedifÂ*.htm for more details about DATEDIF. -- HTH RP (remove nothere from the email address if mailing direct) "CPD174" wrote in message ... I want to figure the age of a person based on two entered dates, their birthday and another date of occurrance. I want this to reflect whether or not their birthday has yet occurred in this calendar year. |
#5
|
|||
|
|||
DateDif sometimes retrn WRONG Value for exm.:
calculate datedif (by days) for 12/31/2004 3/1/2005 "ness" wrote: Thank you - a great help! Vanessa Leonard "Bob Phillips" wrote: Use the DATEDIF function. =DATEDIF(birthdate,TODAY(),"y"Â*) See www.cpearson.com/excel/datedifÂ*.htm for more details about DATEDIF. -- HTH RP (remove nothere from the email address if mailing direct) "CPD174" wrote in message ... I want to figure the age of a person based on two entered dates, their birthday and another date of occurrance. I want this to reflect whether or not their birthday has yet occurred in this calendar year. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
calculate hours just can't figure it out | Excel Worksheet Functions | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Not able to calculate. | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |