Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I calculate ages of employees in Excel?
I am looking to calculate the exact age of employees in my office. Using the
start dates as =now() and their respective date of birth I want to know the age in years, months and days. Is there a formula for calculating this? |
#2
|
|||
|
|||
Chaka, have a look here
http://www.cpearson.com/excel/datedif.htm#Age -- 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 2003 "ChakaCaen" wrote in message ... I am looking to calculate the exact age of employees in my office. Using the start dates as =now() and their respective date of birth I want to know the age in years, months and days. Is there a formula for calculating this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Select a name from a list of employees using Excel | Excel Discussion (Misc queries) | |||
How does Excel 2003 calculate trendlines with respect to axes? | Charts and Charting in Excel | |||
Calculate date of birth in Excel | Excel Worksheet Functions | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |