Extraction of employees no longer in service
Hello everybody,
in a list or data in the range from A2 to S10 but it could be larger, I should extrapolate the people who are no longer in service in the file that I attach as an example the people who satisfy the request are
Balduzzi joe
hired on 05/10/2015 and terminated 16/12/2018 line 3;
summary 01/28/2019 and terminaded 08/20/2020 line 7 therefore no longer works.
Baccinelli Peter
hired 25/2/2019 terminated 13/02/2022
|