# WHAT IS TOTAL EXPERIENCE CALCULATOR?

Posted on 02nd Aug 2018 | 1054 views

5 avg. rating (100% score) - 1 votes

## Experience Calculator

Experience Calculatoris what gives you information about an employee’s total experience with the current company, previous company or the experience in total or the experience in the current domain. The input that is needed is just the start date. To calculate the previous company experience you need the respective employee joining and leaving date of the previous company whereas to calculate the experience with the current company the joining date along with the date till which the experience is to be calculated are needed as inputs.

## Total experience calculator

Total experience calculatorincludes all the experience tenures with different companies in the past and as well the current company experience till date. Experience calculator in yearsis a simple calculation done with the above components given as inputs.

Check with the formula below each of which is to calculate experience in months or years or days. These formulas are used to calculate the candidates tenure till date.

Years of experience calculator: =DATEDIF(B2,NOW(),"Y"),where B2 is the start date. For total experience B2 will be the date when the candidate started first employment, for experience with current company B2 will be when the employee has joined the current company.

Use the formula =DATEDIF(B2,NOW(),"M"), to calculate the years of experience in months count. Chose an empty cell where you want the months count to be calculated and enter the formula then drag down the cell to calculate the same for all those input fields.

In the same way if you want to calculate the experience in terms of both years and months then use the formula =DATEDIF(B2,C2,"y") & " years, " & DATEDIF(B2,C2,"ym") & " months ". In this case B2 will be the joining or entry date and C2 will be leave date or current date.

## 0 Comments on WHAT IS TOTAL EXPERIENCE CALCULATOR?

Comment as a guest:

### POPULAR POSTS

 What is Appointment letter Format? 26th Jun 2018 Top 10 facts why you need a cover letter? 08th Jun 2018 Are you looking for a job in Event Management? 28th May 2018 Pharmaceutical job opportunities on rise in Gulf 23rd May 2018 MNC Vs Startup: Are you Confused to Choose between? 09th Aug 2017 Perspectives of Unemployment in India 01st Jul 2013

View All

How consistently does your organization reward you for good work?

Very difficult

Reasonably consistently

Not at all consistently

View All

View All

View All
• 2018
• January
• March
• April
• 2017
• January
• February
• March
• April
• May
• July
• 2016
• February
• March
• April
• May
• June
• July
• August
• September
• November
• December