How to calculate Length of Service from Date of Joining in MS Excel

[MuhammadHamid-lf]

Dear Sir,
I really Appriciate you. You have solved my Major Problem by your providing formula.

Thank You very

[thejaswinikulkarni]

Hi, This is very useful and explained in a simple manner. How do I add Prior Experience to derive an employee's total years of experience? Please share.

[nirmalrana]

What to do if DATEDIF function is not available in the excel 2019, any alternative there anyhow?

[swibiinternet]

I need if same person relieved from the job and again that person joined, now i want to calculate for total month year days.worked

[lakshmi]

Hii i applied this formula and I got results but in this form 2years0month9days there is no gap

[smitadulera]

Agar isme today ki jagah koi aur date se Krna ho to kese kre please suggest me

[ritaamondi]

How about using a specific date not just today's date??

[shantinaidu]

What if we want only days then what will be formula

[akukaiddrisuazimbe]

I want a formula that will calculate if you have day, month and exact number of years without the year you where born, example 18th January, 6years. Thank you

[vishwasvsh]

Sir how to add.. please assist
3yrs, 6month, 8days. With
6yrs, 9month, 30days

[piegaming]

I have a one problem can you please solve it?

[nishaalikhan]

But some of it coming out as 52 months… why? 😢

[nazmulhassan]

এই ডেট যদি আমি ১ বছরের নিচে & ১ বছরের উপরে আলাদা করে দেখতে চাই কি কি করব