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

[@MuhammadHamid-l9f]

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

[@techstudio8268]

Thanks for your valuable comments 🙂 please subscribe to my channel and also share my videos with your friends 😊

[@AnilkumarKumar-gw2hr]

Superb explanation 👌

[@techstudio8268]

Thank you Bro 🙂

[@memesbyUmair]

Thank you Big Boss,,, 5/5 Rated

[@techstudio8268]

You are most welcome ☺️ please subscribe to my channel and also share my videos with your friends 😊

[@mdabdulbatenofficial4949]

Very help full, lots of thanks

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@Realtalkswithsachin]

Many Thanks 👍🏻
Keep it up

[@techstudio8268]

Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊

[@maricelbuenconsejo8588]

thank you! what a great help!

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@thejaswinikulkarni2232]

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.

[@techstudio8268]

For this you need to define one more cell

[@Ashraful_Antor]

Its worked nicely. Thank you

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@jeyasuriyaramalingam3597]

Thank You. It was really helpful. :)

[@techstudio8268]

Thanks for your valuable comments 🙏 please subscribe to my channel and also share my videos with your friends 😊

[@sachinraval9251]

Excellent..😊

[@techstudio8268]

Thanks 😊 please subscribe to my channel and also share my videos with your friends 😊

[@techstudio8268]

Thanks 😊 please subscribe to my channel and also share my videos with your friends 😊

[@mackyty-v5182]

I love this!!!!

[@techstudio8268]

Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊

[@fouzianaseem8457]

You are great

[@techstudio8268]

Thanks for your comments 😘 please subscribe to my channel and also share my videos with your friends 😊

[@anitaroselene3385]

Very helpful.

[@techstudio8268]

Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊

[@nirmalrana9439]

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

[@techstudio8268]

Let me check

[@swibiinternet2397]

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

[@techstudio8268]

Well, it's little bit difficult, but you can code smartly using the same code

[@MarilynJacinto-ds6ih]

thank you for sharing

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@akukaiddrisuazimbe6019]

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

[@techstudio8268]

Please check my other Excel videos you will find this requirement

[@lakshmi0331]

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

[@techstudio8268]

Please use spaces in double quotes

[@ritaamondi8375]

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

[@techstudio8268]

Give the date in date format in place of today's date

[@shantinaidu8728]

What if we want only days then what will be formula

[@techstudio8268]

You need to write days function in separate cell

[@vishwasvsh3]

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

[@techstudio8268]

Please edit the date of joining with your requirement

[@smitadulera4344]

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

[@techstudio8268]

In that case you need to specify date in date format

[@piegaming8210]

I have a one problem can you please solve it?

[@techstudio8268]

Please tell your problem

[@nishaalikhan7222]

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

[@techstudio8268]

It's weird 😕

[@nishaalikhan7222]

@@techstudio8268 , nahh.. I forgot to key in "ym" for months.... Anyway, great video!

[@salmanahmedsams]

Thanks

[@techstudio8268]

You are most welcome 🤗 please subscribe to my channel and also share my videos with your friends 😊

[@devendraparvatkar5583]

how can i download this file ?

[@techstudio8268]

Not getting sir

[@devendraparvatkar5583]

@@techstudio8268 How to download?

[@aishwaryak1901]

14years6months25days

[@aishwaryak1901]

How to give space before months and days

[@techstudio8268]

👍

[@nazmulhassan8049]

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

[@techstudio8268]

Sorry I can't understand this language

[@chinnarasuv]

Not use

[@chinnarasuv]

Sorry it's useful of one

[@techstudio8268]

Thanks 🙏 please subscribe to my channel and also share my videos with your friends 😊

[@ssm-oq1cc]

Bakwas, Jalebi kyon banate ho .?

[@techstudio8268]

Any wrong in this learning, please let me know bhai