Calculate Employee Length of Service - Excel DATEDIF Function

Calculate the length of service of an employee in Excel using the DATEDIF function. The DATEDIF function calculates the difference between two dates.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[RG-kfii]

thank you . Finally I got a video to help me calculate years and months. Awesome video

[christinatorres]

Thanks a million for this. It helped me calculate what I needed. I so appreciate your time, skills and experience.

[govardhanakrishna]

This really helped me a lot during Data preparations. Thank you.

[kellyweese]

is it possible to add multiple lengths of service together? For example, I used the DATEDIF formula and produced 8y, 9m, 13d and 3y, 8m, 3d. Is there a formula that will total that to 12y, 5m, 16d?

[gamevidzzy]

Great job Brothers, you have helped thousands already!

[glennelliott]

Thank you - was really helpful and got me out of a little spot this morning!

[jordanhoutz]

Now, how do you add multiple people's service together to get cumulative years and months of service between them?

[christyhagood]

This worked perfectly!  Now, I'd like to conditional format the Length of Service column if someone has been with us for 10 years, 15 years, etc. Can you guide me on how to do that please?

[kwanhuiying]

Amazing!! What if I just need to classify is this id number is current employee and not current employee?

Thank you!

[vixenmmh]

Thanks so much...u made my life 10x better. Subscribed.

[Knightstalker]

Thank you very much for this formula I was helping my older brother out with his assignment over the phone for hours and he thinks im a god at excel now lmao

[cherylyeo]

You are a life saver! My boss wanted a file on this for days and I've got this all done within minutes after much help from you here!!! Thank you so so much Computergaga!!!

[pt]

Thank you, this video has helped tremendously as a semi-beginner for Excel. If I have to calculate by every 5 years, does the same function applies? Thank you in advance for your response.

[blablah]

Hi you made a lottery number generator like 1 year ago.
Was wondering if you can tell me how to let the numbers generated appear on each individual ball instead of all 6 at once.
Thanks.

[toniabuie]

Thanks so much! You saved me alot of work!

[hueyshappyhub]

hi i hope u could reply to my query..i used your formula but when i drag down the formula to see other results..it shows #value! to some other rows..and some are ok..tnx like..06-30-1977 to 01-02-1979.

[Joshi]

Thank you That was really helpful in creating my data

[Phnx]

This is great, but any ideas as to how I would then go on to work out the average tenure of a group of staff who have this tenure calc?

[gissellandreaa]

What if I want to use the current date? But I want it to update automatically each month?

[ellayen]

this video so useful for me，thank you so much sir