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

Copper Contributor

how to find column total for excel using datedif function

 

1 Reply

@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() ) )