Employees over the year calculation

[Rvbicon]

Dear experts,

I have an excel list of all employees with the hire date and termination date since the start of the company in 2002 up to now, 3 columns.
The list includes the employees which are currently employed and the ones who left. So the employees who left have a hired and termination date, the currently employed only a hire date.
I would like to pull data from this list, I want to have a count of the number of active employees (employed) each year since 2002 up to now, the number leaving each year and joining every year. How do I go about pulling this data in excel?
Thanks.

 

[sandy666]

you can try Power Query and/or Pivot Table
post an example of your data using XL2BB