Forum Discussion
Tracking Open Recruitment Roles Monthly
I have created a KPI sheet for my organization, tracking Active Employees by month, hires, exits, turnover, etc. I have the spreadsheet build, and I have collums E-P with the Month on it, and I have ...
Assuming in E2:P2 you have dates (end of month) formatted as months, and you have no empty rows in the range. Formula could be like
=COUNTIFS($S$3:$S$15, "<=" & E$2, $T$3:$T$15, ">=" & E$2)