Skip to main content

Kutools for Office ā€” One Suite. Five Tools. Get More Done.

How to calculate the length of service from hire date in Excel?

Author Xiaoyang Last modified

If you have a range of data including employee names and their date of joining your company in a worksheet, now, you may want to calculate their length of service, it means to get how many years and months an employee has worked for your company. This article, I will talk about quick method to solving this job for you.

Calculate the length of service from the hire date with YEARFRAC function

Calculate the length of service from the hire date with an amazing feature

Calculate the length of service from the hire date with DATEDIF function

Calculate the length of service from the hire date to today with DATEDIF function

Calculate the length of service from the hire date with YEARFRAC function

To calculate the length of service from the hire date and a specific date, the YEARFRAC function can help you.

Please enter or copy the following formula into a blank cell:

=INT(YEARFRAC(B2,C2))

Note: In the above formula, B2 is the hire date cell and C2 is the end date cell.

Then drag the fill handle to copy the fromula to other cells you need, and you will get the person's lenght of service in years.

Calculate the length of service with YEARFRAC function

Calculate the length of service from the hire date with an amazing feature

It is somewhat difficult for you to remember so many formulas, but, if you have Kutools for Excel, with its Date & Time Helper feature, you can quickly calculate the length of service in years, months, days, years + months + days or other formats as you need.

Kutools for Excel offers over 300 advanced features to streamline complex tasks, boosting creativity and efficiency. Itegarate with AI capabilities, Kutools automates tasks with precision, making data management effortless. Detailed information of Kutools for Excel...         Free trial...
Note:To apply this Date & Time Helper, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily.

After installing Kutools for Excel, please do as this:

1. Click a cell where you want to locate the result, and then click Kutools > Formula Helper > Date & Time helper, see screenshot:

clcik Date & Time helper feature of kutools

2. In the Date & Time Helper dialog box, do the following operations:

  • Check Difference option from the Type section;
  • In the Arguments input textboxes, select the cells which contain the hire date and end date separately;
  • Then, choose the output result type as you need. For example, you can get the length of service in years, months, years + months + days, years + months and so on.

specify the options in the dialog box

3. After finishing the settings, click OK button, and you will get the first calculated result, then, you just need to drag the fill handle to fill this formula to test cells, and now you will get the following result as you need:

get the result by kutools

Click to Download Kutools for Excel and free trial Now!

Calculate the length of service from the hire date with DATEDIF function

If you need to calculate the length of service in exact years months and days, the DATEDIF function in Excel can do you a favor.

Calculate the length of service in years:

Please enter or copy the following formula into a blank cell:

=DATEDIF(B2, C2, "y")& " Years"

Calculate the length of service in years

Calculate the length of service in years and months:

Please apply the following formula:

=DATEDIF(B2,C2,"y")&" Years, "&DATEDIF(B2,C2,"ym")&" Months"

Calculate the length of service in years and months

Calculate the length of service in years, months and days:

Apply the following formula:

=DATEDIF(B2,C2,"y") & " Years, " & DATEDIF(B2,C2,"ym") & " Months, " & DATEDIF(B2,C2,"md") & " Days"

Calculate the length of service in years, months and days

Note: In the above formula, B2 is the hire date cell and C2 is the end date cell.

Calculate the length of service from the hire date to today with DATEDIF function

Someitmes, you may want to calculate the length of service from hire date to today, so, every day you open the worksheet the length of service will be updated automatically. In this case, you should combine the TODAY function within the DATEDIF function.

Please apply any one below formulas to your need:

=DATEDIF(B4, TODAY(), "y")& " Years"
=DATEDIF(B4,TODAY(),"y")&" Years, "&DATEDIF(B4,TODAY(),"ym")&" Months"
=DATEDIF(B6,TODAY(),"y") & " Years, " & DATEDIF(B4,TODAY(),"ym") & " Months, " & DATEDIF(B4,TODAY(),"md") & " Days"

Calculate the length of service with DATEDIF function

More relative articles:

  • Count The Number Of Days / Workdays / Weekends Between Two Dates
  • Have you ever needed to count the number of days between two dates in Excel? May be, sometimes, you just only want to calculate the workdays between two dates, and sometime, you need to count the weekend days only between the two dates. How could you count the number of days between two dates in a certain condition?
  • Calculate Days Hours And Minutes Between Two Dates
  • Supposing, you have two columns of date time cells, and now, you want to calculate the difference in days, hours and minutes between these two date time cells as following screenshot shown. This article, I will talk about some methods to solve this task for you.

Best Office Productivity Tools

šŸ¤– Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functionsā€¦
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more
Use Kutools in your preferred language ā€“ supports English, Spanish, German, French, Chinese, and 40+ others!

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

All Kutools add-ins. One installer

Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.

Excel Word Outlook Tabs PowerPoint
  • All-in-one suite ā€” Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
  • One installer, one license ā€” set up in minutes (MSI-ready)
  • Works better together ā€” streamlined productivity across Office apps
  • 30-day full-featured trial ā€” no registration, no credit card
  • Best value ā€” save vs buying individual add-in