Does this mean they have to have worked on 90 distinct days before thy get their bonus, or they have to have worked at least 90 days ago?Their hourly bonus start after 90days worked.
Thanks@ABC111
Enter 2 new column headers of Entitled Date at E1 and Counted? at F1
Enter Formula below then fill down the formula
=MINIFS($A$2:$A$4376,$B$2:$B$4376,B2)+90 at E2
=IF(E2-A2>0,"Not Counted", "Counted") at F2
Refresh and arrange pivot table as shown
Click the Counted at Slicer on the right then show their entitled/counted labor hours
Hope this helps
View attachment 11038