To calculate if employee worked past 90days or not -in order to entitle for hourly bonus

ABC1

New Member
Joined
Aug 30, 2021
Messages
29
Office Version
  1. 2016
Platform
  1. Windows
Hi
Would like to calculate past 90days past. Employees hourly bonus start after 90days worked.
Thanks.
I did post this question to ExcelGURU forum as well. Currently I am working in May month So I have to go back Feb month data to verify hrs.
 

Attachments

  • Bouns hrs.PNG
    Bouns hrs.PNG
    40.6 KB · Views: 10

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
I did post this question to ExcelGURU forum as well.
Thanks for letting us know that. Could you please post a link to your thread there in case helpers here want to check if a solution has already been provided in the other forum? Posting of the actual link is stipulated in #13 of the Forum Rules
 
Upvote 0

Forum statistics

Threads
1,223,702
Messages
6,173,967
Members
452,539
Latest member
delvey

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top