Forum Discussion

justus1235's avatar
justus1235
Copper Contributor
Apr 28, 2023

how to use datedif in excel and finding the total years of experience

how to find column total for excel using datedif function

 

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    justus1235 

    Depends on your Excel version and how you calculate years of experience (if some breaks), in general it could be like

    =SUM( YEARFRAC(+start, TODAY() ) )

Resources