Hello all, I am new to excel and have no clue how any of this works. Is there a formula to count 90/180 days on a calendar. The company I work for awards employees for working 90/180 without taking a a sick day. Is there a way to track this on a spreadsheet. I am using a template that was provide by excel but I know nothing about formulas or countif that would allow me to track this automatically. The counter has to reset after 90/180 day so that it shows that the employee has earned a day off. Thank you in advance for your help. -Jimmy-
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
contif formula
- Thread starter jfong
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 92,373
- Office Version
- 365
- Platform
- Windows
Duplicate to: 90/180 day tracker
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
Upvote
0
- Status
Similar threads
