Calculating Years of Service/Length of Service

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...