Hello
I have a spreadsheet that contains data for both active and inactive employees.
My column for "Termination date" has a mixture of leave dates for employees who have left and blank fields for active employees. Is there a way to calculate the tenure for all employees that have left and who are still current?
Thank you
I have a spreadsheet that contains data for both active and inactive employees.
My column for "Termination date" has a mixture of leave dates for employees who have left and blank fields for active employees. Is there a way to calculate the tenure for all employees that have left and who are still current?
Thank you