To calculate if employee worked 90 days or not in order to Entitle for Hourly Bonus

ABC111

New member
Joined
Sep 15, 2021
Messages
12
Reaction score
2
Points
3
Excel Version(s)
2016
Hello To All,
I would like to calculate if employee worked 90days back. There hourly bonus start after 90days worked.
Please,
Thanks for your time and effort.
 

Attachments

  • Excel Guru-try.xlsx
    108.9 KB · Views: 5

ricklinty

New member
Joined
Jul 1, 2022
Messages
6
Reaction score
0
Points
1
Excel Version(s)
Excel 365
@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
1658988129166.png
 

Attachments

  • Excel Guru-try.xlsx
    184.6 KB · Views: 5

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,170
Reaction score
12
Points
38
Excel Version(s)
365
Come on @ABC111 , you've know the rules about cross-posting, you've been told about them left, right and centre; provide links to where you've cross-posted this topic.
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,170
Reaction score
12
Points
38
Excel Version(s)
365
Their hourly bonus start after 90days worked.
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?
Seems unfair if someone gets their bonus if they only worked one day more than 90 days ago.
 

ABC111

New member
Joined
Sep 15, 2021
Messages
12
Reaction score
2
Points
3
Excel Version(s)
2016
Hi to All,
I am really sorry to missed copy past link.
Thanks to all. Specials thanks to @ricklinty
 

ABC111

New member
Joined
Sep 15, 2021
Messages
12
Reaction score
2
Points
3
Excel Version(s)
2016
@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
Thanks
 

ABC111

New member
Joined
Sep 15, 2021
Messages
12
Reaction score
2
Points
3
Excel Version(s)
2016
Hi to All,
MINIFS function is not available in my excel. I am using Excel 2016. how can we do without minifs function.
Please, help me
Thanks
 

ABC111

New member
Joined
Sep 15, 2021
Messages
12
Reaction score
2
Points
3
Excel Version(s)
2016
Thanks. I was following that example(link). But wasn't working for me. because I was making mistake to drag formula.
Now I copy and paste formula and it is working
Thanks lots
 
Top