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:
=DAYS(TODAY(),G2)/365
Length of Service Formula:
=DATEDIF(G2,TODAY(),"Y")&" Years, "&DATEDIF(G2,TODAY(),"YM")&" Months, "&DATEDIF(G2,TODAY(),"MD")&" Days"
