![]() |
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? |
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? |
All times are GMT +1. The time now is 01:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com