I have already calculated one field (J1) correctly and works Total Years of Employee: =DATEDIF(G1,H1,"y")&" years "&DATEDIF(G1,H1,"ym")&" months " &DATEDIF(G1,H1,"md")&" days ". 35 years, 11 months, 27 days.
The second field (K1) is correct and working...=DATEDIF(G6,H6,"y")&" years "&DATEDIF(G6,H6,"ym")&" months " &DATEDIF(G6,H6,"md")&" days ". 59 Years, 5 months, 7 days.
I want to create a third field (L1) and add both of these together to determine a TOTAL number of years between them. I get an "#VALUE error. is this possible ??
The second field (K1) is correct and working...=DATEDIF(G6,H6,"y")&" years "&DATEDIF(G6,H6,"ym")&" months " &DATEDIF(G6,H6,"md")&" days ". 59 Years, 5 months, 7 days.
I want to create a third field (L1) and add both of these together to determine a TOTAL number of years between them. I get an "#VALUE error. is this possible ??