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.

 

Customizing Excel Ribbon to call VBA routine | Cemtech Training Center Puchong, Selangor Melaka

 

Here is how the formula looks like.

Customizing Excel Ribbon to call VBA routine | 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.

 

 Customizing Excel Ribbon to call VBA routine | Cemtech Training Center Puchong, Selangor Melaka

 

 

By Bee Bee Ong  | Google

 

Cempaka Technology Sdn Bhd

Pusat Latihan Komputer Cempaka
~Your HRDC Premiere Training Provider~
64-2, Jalan Puteri 2/2, Bandar Puteri Puchong, 47100 Puchong Selangor, Malaysia. Tel: 603-80684461
1-28, Jalan PM4, Plaza Mahkota, 75000 Melaka. Tel: 606-2835955
Instant SSL