ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I calculate ages of employees in Excel? (https://www.excelbanter.com/excel-worksheet-functions/6423-how-do-i-calculate-ages-employees-excel.html)

ChakaCaen

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?

Paul B

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