Posted on 02nd Aug 2018 | 2544 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.

Experience Calculator

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.


Comment as a guest:


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

Have your Say!

View All

How consistently does your organization reward you for good work?

Very difficult

Reasonably consistently

Not at all consistently


Press Corner

View All

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status