Calculate Tenure in Excel with Days Function

Calculate Tenure in Excel using Days Function video will help you learn how to use Days Date Function in Excel. In this demo you will learn how to calculate tenure of an employee using days funtion. You can calculate the tenure either in days, months or years format.

This applies to:
Excel 2007 and above

#excelLearningSeries #excel #excel2016 #excelDateFunction #exceldata #calculation #tenure #days

[sulja]

Thank you so much! I was struggling with this and luckily I found your video

[kahalisujoy]

Thank you so much for sharing this video. it's really a great help to me.
I have a query - suppose 3.03 (3 years & 3 months) in one cell and 3.11 (3 years & 11 months) in another cell. now if we add both cells then it will come to 3.03 + 3.11 = 6.14. But how may I calculate it as year and month as 7.2 which means 7 Years & 2 months?
I'm looking forward to hearing back from you.

[CoryKreeck]

Nice work! Thanks - you are one of the best out there

[Mishkafofer]

I think this function is useful for users that are not aware that Excel can do date calculations on valid days. I am not sure why use this function if we can use regular date calculations.

[babonghosh]

This is helpful. Can plz suggest how to convert it into months

[ntvca]

I am trying to build a bar graph for tenure ending at age 70. Steve is on the committee from 2014 Q2 to age 70 Q2. Is this possible?

[ArchanaKrishnaBongane]

How to do the bucketing of the values like 0 to 6 months or 6 to 12 months frim different rows

[kunaldiyali]

Hello Syed,

This is helpful, but I need an understanding on why it's it calculating the months appropriately?

I wanted to know the calculation for let's say, 3.3 which is 3 years & 3 Months.

Would you help me with that?

[jebarlinrenjith]

Thanks for your videos. what should we do to get the number of months. i.e 6 Years and (1 - 12) months ??

[PradeepKumar-yptc]

Sir in the above video, can you add some more data and segregate employees based on there tenure, say between 12 months to 1 month and so on

[chamdaigolmei]

Tell me the formula i. e if born in 08 Oct 2003 when will i reach 20 years. How to calculate in excel.

[PamPerryJones]

One question; how do you show the tenure in year, month format? Not a decimal - thanks!

[Aliakbar-resj]

Dear; i want to calculate receiving a period with approval from Government. 10 month 28days and i want to merge and select total period of Service +in 08y-08m-18d to complete make as 10y-0m-0days. Can you help me to make it. and instruct to me for made it.

[alibuchh]

I have to calculate stay, my
Date of joining as on date
Please explain formula

[adrianbonillacortes]

Hi Syed, thanks for the video, instead of giving me the number of days i want it to bring me +6 / -6

[rituparnopaygeek]

When I downloaded the excel file and opened it, there's an error in the cells where the tenure should've been calculated ... any insight on that? Error message is "#NAME?"
Thanks

[latharajkumar]

Sir, how to add employees previous experience and present experience ... Say 10.08 (10 year 8 months) and should be 22 year 6month.... How to calculate using excel. Please reply

[minishona]

Mera answer to nhi aa rha... Me b system pr kr rhi hu same tenure.. nd formula b yhi use kr rhi hu

[zohaibhassan]

Start date (in E2 Cell) 4/03/2017 End Date (in F2 cell) 21/01/2021 Formula =DATEDIF(E2, F2, "y")
Sir its not working please help me