Excel Tutorial - Calculate the length of services of employees in years, months and days

 

 

Want to know how long in years, months and days the employees have been working for a company? What are the lifespan of the machines/assets in your company?

You may use the DATEDIF() function.

 

Excel Tutorial - Calculate the length of services of employees in years, months and days | Cemtech Training Center Puchong Selangor, Melaka

 

Here is how the formula looks like.

Excel Tutorial - Calculate the length of services of employees in years, months and days | Cemtech Training Center Puchong Selangor, Melaka

 

Here is more information on the DATEDIF functions:

DATEDIF – Calculating the Duration between Two Dates

 The DATEDIF function computes the duration between two dates in a variety of different intervals, such number of years, months, or days.

 

 Excel Tutorial - Calculate the length of services of employees in years, months and days | Cemtech Training Center Puchong Selangor, Melaka

 

 

By Bee Bee Ong  

Cempaka Technology Sdn Bhd

Pusat Latihan Komputer Cempaka
~Your HRDC Premiere Training Provider~
Unit 6, Level 4, SetiaWalk Mall (Block K), SetiaWalk, Persiaran Wawasan, Pusat Bandar Puchong, 47160 Puchong, Selangor, Malaysia.
Tel: 603-80684461, Fax: 603-80684240
1-28, Jalan PM4, Plaza Mahkota, 75000 Melaka, Malaysia
Tel: 606-2835955, Fax: 606-2845955