Calculation of work experience

[srdjan013]

Dear All,

i need help. I need to calculate the total length of service for all periods collectively. What I was able to do with the DATADIF formula was to calculate the difference between the start data and the end data. This is found in cells F4, F5, F6. In cell F15, I need to have the total sum of work experience. Also, in cells C15, D15 and E15 I need to have a total sum in years, months and days so that I can convert days into months, months into years.
I hope I explained it well.
Please help. Thank you

 

[Cubist]

Try:

Book1
	A	B	C	D	E
1
2
3			Year	Month	Days
4			1	8	27
5			1	6	4
6			3	9	9
7
8
9
10
11
12
13
14
15		Total	7	0	10
Sheet1

Cell Formulas
Range	Formula
C15	C15	=SUM(C4:C6)+QUOTIENT(SUM(D4:D6)+QUOTIENT(SUM(E4:E6),30),12)
D15	D15	=MOD(SUM(D4:D6)+QUOTIENT(SUM(E4:E6),30),12)
E15	E15	=MOD(SUM(E4:E6),30)

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Calculation of work experience
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[kvsrinivasamurthy]

In C4

=DATEDIF(A4:A11,B4:B11,"Y")

In D4

=DATEDIF(A4:A11,B4:B11,"YM")

In E4

=DATEDIF(A4:A11,B4:B11,"Md")

In F4

=IF(C4:C11=0,"",C4:C11&" Years ")&IF(D4:D11=0,"",D4:D11&" Months ")&IF(E4:E11=0,"",E4:E11&" Days")

 

[srdjan013]

Thank you all.