Total Experience

[binoyfalcon]

Hi ,
how to get total experience year from year and month value

thank you

 

[ETAF]

as you are concartenating - the display is in text
so *1 or +0
=(DATEDIF(B6,C6,"Y")&"." & DATEDIF(B6,C6,"YM"))*1
then it will sum

 

[vletm]

binoyfalcon
This sample could show enough expected result too.

 

[Peter Bartholomew]

I decided to stick with text in year-and-month format using the deprecated DATEDIF function.

SinglePeriod
= LET(
      years,  DATEDIF(start,1+end,"Y"),
      months, DATEDIF(start,1+end,"YM"),
      TEXT(years,"0\y;;;") & TEXT(months,"[<10]_m_m 0\m; 0\m")
  )
 
TotalExperience
= LET(
      days,   SUM(1+end-start),
      years,  DATEDIF(0,days,"Y"),
      months, DATEDIF(0,days,"YM"),
      TEXT(years,"0\y;;;") & TEXT(months,"[<10]_m_m 0\m; 0\m")
  )

The awkward bit was ensuring the year lined up as one goes from single to double digit month numbers.

 

[AVK]

In "B11" =MIN(B6:B10)
In "C11" =MAX(C6:C10)
IN "D11" =DATEDIF(B11,C11,"Y")&"." & DATEDIF(B11,C11,"YM")