Experience Calculator
Calculate your total work experience in years, months and days instantly with our free Experience Calculator. Perfect for resumes, HR records, and Canada immigration.
Add all your previous jobs below to get your total combined work experience (useful for Canada immigration / PR points, or overall career experience).
Experience Calculator
Free Download: Experience Calculator Excel Template
Ready-made experience calculator Excel sheet. Download and use offline on your device.
Download Excel Template (.xlsx)An Experience Calculator is a free online tool that works out your exact work experience from your Date of Joining, instantly, in years, months and days. Use it when you are updating a resume, filling an HR or job application form, checking eligibility for a government job, or estimating your work experience for a Canada immigration profile. You do not need to count days on a calendar or build an Excel formula.
This page also explains how the calculation works, so you can verify the result yourself: the manual method, the Excel DATEDIF formulas, conversion tables for years, months and days, how to add up multiple jobs without double counting, and how to answer the common form question "how many years of total work experience do you have?"
• Experience = End Date − Date of Joining, shown as years, months and days
• Still working? Use today's date as the end date
• Total months = (Years × 12) + Remaining Months
• Decimal years = Total Months ÷ 12 (6 years 6 months = 6.5 years)
• Excel:
=DATEDIF(A2, TODAY(), "y") gives complete years
How to use the calculator · Experience from date of joining · Excel formulas · Years, months and days tables · Multiple jobs · How experience is counted · Canada immigration · Answering “total experience” · Common mistakes · FAQ
How to Use the Experience Calculator
- Enter your Date of Joining. This is the first day you started the job.
- Enter your last working date. If you are still employed, you can leave the end date as today's date. To check your experience on a particular day, for example the last date of a job application, enter that date instead.
- Read the result. The calculator shows your total experience in years, months and days.
- For more than one job, switch to the “Multiple Jobs” tab, add every job's start and end date, and the tool combines them into one total.
How to Calculate Experience from Date of Joining
To calculate experience from your date of joining, find the difference between the joining date and the end date (or today, if you are still working), then break it down into years, months and days.
(expressed in Years, Months, and Days)
Example 1: Joining date to today
This is also how you calculate experience from date of joining to today: today's date simply takes the place of the end date. It lets you check your running tenure at any time, without waiting for an appraisal letter or an HR email.
Doing it by hand: the borrowing method
If you want to verify the calculator manually, subtract year from year, month from month and day from day. When a number goes negative, borrow from the next larger unit, exactly like normal subtraction.
Years: 2026 − 2019 = 7
Months: 3 − 8 = −5, so borrow 1 year: 6 years and 7 months
Days: 5 − 18 = −13, so borrow 1 month: 6 years 6 months, and the days become −13 + 28 (days in February 2026) = 15
Result: 6 Years, 6 Months, 15 Days (2,391 days in total)
The number of days you borrow is the length of the month just before the end date. That is why the same joining date can give slightly different day counts in different months, and why counting every month as 30 days gives wrong results.
Should the last day be counted?
The standard date difference does not count the last day. Some employers do, because the last working day is a day worked. The difference matters most when the employment ends on the last day of a month.
Without counting the last day: 0 Years, 11 Months, 30 Days
Counting the last day (end date 1 January 2026): 1 Year, 0 Months, 0 Days
If a form or an experience letter counts the last day, add one day to your end date before calculating. If you are unsure, follow the method used in your relieving letter.
How to Calculate Experience in Excel
People who search for how to calculate experience in Excel use the DATEDIF function. It compares a start date and an end date and returns the gap in the unit you ask for. Put the joining date in A2 and the end date in B2, then use:
DATEDIF(A2, B2, "ym") & " Months, " &
DATEDIF(A2, B2, "md") & " Days"
To calculate experience from date of joining to today in Excel, replace the end date with the TODAY() function. The result then updates on its own every time you open the sheet, which suits HR teams that maintain a live tenure tracker.
DATEDIF(A2, TODAY(), "ym") & " Months, " &
DATEDIF(A2, TODAY(), "md") & " Days"
What each DATEDIF unit means
| Unit | Returns |
|---|---|
"y" | Complete years between the two dates |
"m" | Complete months between the two dates (total months) |
"d" | Total days between the two dates |
"ym" | Months left over after removing complete years |
"md" | Days left over after removing complete years and months |
"yd" | Days left over after removing complete years |
Other useful experience formulas
| What you need | Formula |
|---|---|
| Total months of experience | =DATEDIF(A2, B2, "m") |
| Total days of experience | =B2-A2 or =DATEDIF(A2, B2, "d") |
| Experience in decimal years | =ROUND((B2-A2)/365.25, 1) |
| Count the last day as well | Use B2+1 in place of B2 in any formula above |
| Experience as on a fixed date, such as an application deadline | Type that date in B2 instead of using TODAY() |
| Total months across several jobs (months in F2:F5) | =INT(SUM(F2:F5)/12) & " Years, " & MOD(SUM(F2:F5),12) & " Months" |
Why the Excel formula sometimes goes wrong
- #NUM! error: the start date is later than the end date. Swap them.
- #VALUE! error or a wrong result: the dates are stored as text. Re-enter them or use Data → Text to Columns to convert them to real dates.
- DATEDIF does not appear in the suggestions: this is normal. The function works, but Excel does not list it, so type it in full.
- The days part looks odd: Microsoft notes that the
"md"unit can give inaccurate results in some cases. If the day count matters, verify it with the borrowing method above or with the calculator.
The same formulas work in Google Sheets. Our online calculator follows the same logic, but you do not need to remember the syntax or fix cell formats.
Years, Months and Days: Conversion Tables
Forms often ask for experience only in months, or only in years with a decimal. These two tables let you convert quickly.
Years to months and days
| Years | Months | Approx. Days |
|---|---|---|
| 1 year | 12 | ≈ 365 |
| 2 years | 24 | ≈ 731 |
| 3 years | 36 | ≈ 1,096 |
| 4 years | 48 | ≈ 1,461 |
| 5 years | 60 | ≈ 1,826 |
| 6 years | 72 | ≈ 2,192 |
| 7 years | 84 | ≈ 2,557 |
| 8 years | 96 | ≈ 2,922 |
| 9 years | 108 | ≈ 3,287 |
| 10 years | 120 | ≈ 3,653 |
Days are approximate because leap years add an extra day. For an exact day count, use the dates themselves.
Extra months to decimal years
| Extra Months | Decimal Years | Extra Months | Decimal Years |
|---|---|---|---|
| 1 | 0.08 | 7 | 0.58 |
| 2 | 0.17 | 8 | 0.67 |
| 3 | 0.25 | 9 | 0.75 |
| 4 | 0.33 | 10 | 0.83 |
| 5 | 0.42 | 11 | 0.92 |
| 6 | 0.50 | 12 | 1.00 |
How to calculate years of experience
Your years of experience is the number of complete years between your joining date and the end date. The leftover months and days are shown separately. For example, 6 years and 11 months is reported as “6 years” if the form asks for complete years, “6.9 years” if it accepts decimals, and “83 months” if it asks for months. Write the figure in the unit the form asks for, and do not round up to look better.
How to Calculate Total Experience for Multiple Jobs
If you have worked at more than one company, calculate each job separately and then add the years, months and days. The Multiple Jobs tab above does this automatically and gives you one combined total for your resume, LinkedIn profile or application form.
Years: 2 + 1 = 3
Months: 3 + 8 = 11
Total = 3 Years, 11 Months combined work experience.
Years: 3 + 2 = 5
Months: 8 + 7 = 15, which is 1 year 3 months
Total = 6 Years, 3 Months
What to do with overlaps and gaps
- Gaps between jobs are not counted. Only the periods you actually worked are added.
- Overlapping jobs should be counted once. If you worked two jobs at the same time, the overlapping period is counted only once for total experience, unless the rules you are applying under say otherwise.
Adding blindly gives 60 months, which is wrong. Correct total = 36 + 24 − 6 = 54 months = 4 Years, 6 Months.
Doing this by hand or in Excel means handling each job's dates, carrying months into years and removing overlaps. The calculator does the date arithmetic for you, but always check the jobs you enter for overlaps.
How Work Experience Is Counted for HR and Job Applications
Most employers measure experience as the exact duration between your start date and end date, or today if you are still employed, usually expressed in years and months. The details differ from case to case, so check the rule that applies to you:
| Situation | Usual practice |
|---|---|
| Private job applications | Total duration from joining to relieving date, often rounded down to complete years or months. |
| Government job eligibility | Experience is usually counted as on a stated cut-off date, such as the last date of application. Enter that date as the end date, not today's date. |
| Internships and training | Counted only if the notification says so. Many employers count only full-time paid work. |
| Part-time work | Some rules convert it to a full-time equivalent. Check how the form or authority defines experience. |
| Notice period | Usually counted if you were still employed and paid until the relieving date. |
| Partial months | Some processes round up partial months while others count only full months. Confirm the exact rule. |
If you work for the government and also need to calculate allowances, see our DA Calculator. If you are preparing for a competitive exam alongside your job, our Negative Marking Calculator helps you estimate your score.
How to Calculate Work Experience for Canada Immigration
For programs such as Express Entry, work experience is usually assessed as skilled work done in a recent period, commonly measured in full-time equivalent hours or years. In general, one year of full-time work is about 1,560 hours, for example 30 hours a week for 52 weeks. Part-time work can be converted by hours, so 15 hours a week for 24 months is treated as roughly one year of full-time experience.
Total hours = 20 × 52 × 2 = 2,080 hours.
Full-time equivalent = 2,080 ÷ 1,560 = about 1.33 years.
Use the calculator first to get the exact duration of each job. Then convert it into months or hours, whichever the program uses. Getting a day-level figure first is more reliable than estimating from memory. Eligibility conditions, the recent period considered and how hours are counted depend on the specific program and change from time to time, so always confirm them on the official Government of Canada (IRCC) website before applying.
How to Answer “How Many Years of Total Work Experience Do You Have?”
This is one of the most common fields in job portals and application forms. A few practical rules:
- Use your exact figure. “6 years 4 months” is better than rounding to 7. Recruiters can check dates against your resume.
- If the field accepts only a number, enter complete years (for example, 6) or a decimal (6.3) if decimals are allowed.
- Separate total and relevant experience. If the form asks about experience in a particular skill, count only the time you actually worked in that role or tool.
- Less than a year? Enter it in months, for example “10 months”, or as 0.8 years.
- Write it consistently across your resume, LinkedIn and application. Mismatches raise questions during background checks.
Common Mistakes While Calculating Experience
| Mistake | Why it gives a wrong result |
|---|---|
| Treating every month as 30 days | Months have 28 to 31 days, so the day count drifts. Use the borrowing method or DATEDIF. |
| Adding up years and months incorrectly | Months of 12 or more must be converted to years (8 + 7 = 15 months = 1 year 3 months). |
| Double counting overlapping jobs | Total experience goes up even though you worked only once during that period. |
| Using today's date for a past cut-off | Eligibility is judged on the cut-off date, so your experience on that date is lower. |
| Rounding up to a complete year | 11 months is not 1 year. Many forms and background checks need the exact period. |
| Dates stored as text in Excel | DATEDIF returns errors or wrong values. Convert them to real dates first. |
Online Calculator vs Excel: Which Should You Use?
| Online Experience Calculator | Excel DATEDIF | |
|---|---|---|
| Setup | Open and enter two dates | Create a sheet and type the formula |
| Years, months and days | Shown directly | Needs a three-part formula |
| Multiple jobs | Add jobs in the Multiple Jobs tab | Needs extra columns and overlap checks |
| Best for | Resume, forms, one-off checks | HR sheets with many employees |
Related Calculators
- Attendance Calculator: work out attendance percentage, 75% eligibility and monthly averages
- DA Calculator: calculate dearness allowance for government employees and pensioners
- Negative Marking Calculator: calculate your exam score with negative marking
- SGPA Calculator and SRM CGPA Calculator: convert grades to SGPA and CGPA
- Cash Denomination Calculator: get a note-wise breakup of any amount
You can browse all our tools on the CalcShala homepage.
Frequently Asked Questions
Q: How do I calculate my total years of experience?
A: Enter your Date of Joining and your last working date above. The calculator shows your total experience in years, months and days. For several jobs, use the Multiple Jobs tab.
Q: How do I calculate experience from date of joining to today?
A: Use today's date as the end date. In Excel, replace the end date in your DATEDIF formula with TODAY(), and the result updates automatically.
Q: How do I calculate experience in Excel?
A: Use =DATEDIF(A2, B2, "y") & " Years, " & DATEDIF(A2, B2, "ym") & " Months, " & DATEDIF(A2, B2, "md") & " Days", where A2 is the joining date and B2 is the end date. The Excel section above explains each part and the common errors.
Q: How do I convert experience into months?
A: Multiply the complete years by 12 and add the remaining months. 6 years 4 months is (6 × 12) + 4 = 76 months.
Q: How do I convert 10 years into months or days?
A: 10 years is 120 months, or about 3,653 days once leap years are included.
Q: How do I convert months into years?
A: Divide the months by 12. 30 months is 2.5 years, which is 2 years 6 months.
Q: Is the last working day included in the experience?
A: A standard date difference excludes the last day, while some employers include it. If your relieving letter counts the last day, add one day to the end date.
Q: How do I add experience from two companies?
A: Add the years and the months separately, then convert any months of 12 or more into years. 2 years 3 months plus 1 year 8 months is 3 years 11 months. If the jobs overlap, count the overlapping period once.
Q: Is internship experience counted as work experience?
A: It depends on the employer, notification or program. Many government and immigration rules count only paid, full-time work, while a resume can list internships separately. Check the rules for your case.
Q: How do I calculate experience for a government job as on a particular date?
A: Enter that cut-off date, such as the last date of application, as the end date instead of today's date. That gives your experience as on that date.
Q: Is this useful for Canada immigration applications?
A: It helps you estimate the exact duration of each job before converting it into months or hours. Eligibility rules differ by program and change over time, so confirm them on the official IRCC website.
Q: Does this work the same as the Excel formula?
A: Yes, it follows the same year, month and day logic as DATEDIF, without needing any formula or cell formatting.
Rules for counting experience differ between employers, government departments and immigration programs. This page explains the calculation, but eligibility is decided by the authority that sets the rules. Last updated: October 2026.