New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Calculate Total experience of a person

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Calculate Total experience of a person

Postby anhazarika » Mon Feb 22, 2016 4:01 am

Hello every one,

I am trying to calculate the total experience of a person. I have two fields to consider..

First field :-Past experience= 7.3 (7years 3 months)
Second Field:- date of Joining in current place : 20-Aug-12

Now I need to calculate what is his total experience as on 31-mar-16. Pls help.

I have given the attachment for your reference.
  • 0

You do not have the required permissions to view the files attached to this post.
anhazarika
Rookie
 
Posts: 7
Joined: Dec 18, 2015
Reputation: 0
Excel Version: 2007

Re: Calculate Total experience of a person

Postby pecoflyer » Mon Feb 22, 2016 8:00 am

Hi
find attached a solution using the YEARFRAC function
  • 0

You do not have the required permissions to view the files attached to this post.
A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 129 guests