Dear Team,
I am currently working on an HR Dashboard and I want to be able to use a formula to do 2 things:
A. report the overall current number of employees who are still onboard. This will mean as long as I keep updating the datasheet this number should automatically be updating.
Conditions:
1. Their contract should still be active
2. Their startdate cannot be in the future. Must be today or earlier.
3. In column "I" of the attached sample sheet all the blank cells means those staff are permanent employees so they should also count into the current number.
4. Exclude staff with employee class "Spain"
B. The datasheet for the dashboard will always have data of employees whose contract have ended and employees who are still here. Which formula is best to record in a more dynamic way the number of ACTIVE females and males?
Thanks in advance for the usual support.
Regards,
KB
I am currently working on an HR Dashboard and I want to be able to use a formula to do 2 things:
A. report the overall current number of employees who are still onboard. This will mean as long as I keep updating the datasheet this number should automatically be updating.
Conditions:
1. Their contract should still be active
2. Their startdate cannot be in the future. Must be today or earlier.
3. In column "I" of the attached sample sheet all the blank cells means those staff are permanent employees so they should also count into the current number.
4. Exclude staff with employee class "Spain"
B. The datasheet for the dashboard will always have data of employees whose contract have ended and employees who are still here. Which formula is best to record in a more dynamic way the number of ACTIVE females and males?
Thanks in advance for the usual support.
Regards,
KB