4 Replies Latest reply on Nov 13, 2017 2:55 PM by Deepak Rai

    Count of Active and Terminated employees in any given year

    Shanmukh Bokka

      Hi,

            I need to determine the number of active and terminated employees in any given year. All I have is the hire date, termination date of the employees and their employee status. I am getting this data from mysql, so I cannot use PIVOT function like shown in other discussions pages for solution.

       

      Suppose if I want to know number of Active Employees in 1996, that would include (all employees who were hired before 1996 and active in 1996 ) plus (employees  hired in 1996 and who were Active till the end of 1996.)

       

      Attached is the Sample excel file.