Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I calculate the age of a person?
If I have the date of birth, how do I calulate the age of a person?
Thanks Doug |
#2
|
|||
|
|||
Doug, have a look here for how to do it
http://www.cpearson.com/excel/datedif.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Doug Mc" wrote in message ... If I have the date of birth, how do I calulate the age of a person? Thanks Doug |
#3
|
|||
|
|||
You can use the DATEDIF function to do this. See
www.cpearson.com/excel/datedif.htm for details. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Doug Mc" wrote in message ... If I have the date of birth, how do I calulate the age of a person? Thanks Doug |
#4
|
|||
|
|||
Thanks to BOTH of you!
Doug "Chip Pearson" wrote in message ... You can use the DATEDIF function to do this. See www.cpearson.com/excel/datedif.htm for details. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Doug Mc" wrote in message ... If I have the date of birth, how do I calulate the age of a person? Thanks Doug |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Not able to calculate. | Excel Worksheet Functions | |||
D Sum or SumIF | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |