How to calculate Service Age of an Employee

Formula to calculate service duration of an Employee

Service Age Calculation Formula

=DATEDIF(H3,I3,"y")&" Years "&DATEDIF(H3,I3,"ym")&" Months "&DATEDIF(H3,I3,"md")&" Days"


By using above formula, you can easily calculate total Service Length of any Employee with Year, Month and Day.

Post a Comment

Previous Post Next Post