Calculating Years of Service/Length of Service

Copper Contributor

I have a spreadsheet where I am calculating years of service/length of service. The spreadsheet also has an inactive date. What would I add to the formula that would reflect those employees that have an inactive date? Currently the time on those employees are still counting.




Years of Service Formula:


Length of Service Formula:

=DATEDIF(G2,TODAY(),"Y")&" Years, "&DATEDIF(G2,TODAY(),"YM")&" Months, "&DATEDIF(G2,TODAY(),"MD")&" Days"

1 Reply


Change TODAY() to =IF(H2="",TODAY(), H2)