Excel Newbie91
New Member
- Joined
- Nov 1, 2022
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Hi everyone,
I am a newly hired employee and was given this very outdated calendar to help track my PTO time. Previously they were manually changing every date and manually moving the green accrual box and changing which date it pulls from. I have figured out how to get the calendar to update the dates by changing the year in cell F4 but I’m not sure what to do with the formula they created for the PTO to get entered onto the calendar =IF(OR($H$3=0,$H$3>O7),$L$2,$L$3) It needs to be in the Monday before we get paid and we get paid every other Friday. They have it using the off (non-paid) Friday to decide if it needs to change the PTO rate. Currently we have to manually move this formula up or down a Monday depending which week we get paid. I feel like there should be a way to set it to be every 14 days from a certain date or something so it changes automatically when we change the year date. Is this possible? Can anybody please help me? Thank you in advance.
I am a newly hired employee and was given this very outdated calendar to help track my PTO time. Previously they were manually changing every date and manually moving the green accrual box and changing which date it pulls from. I have figured out how to get the calendar to update the dates by changing the year in cell F4 but I’m not sure what to do with the formula they created for the PTO to get entered onto the calendar =IF(OR($H$3=0,$H$3>O7),$L$2,$L$3) It needs to be in the Monday before we get paid and we get paid every other Friday. They have it using the off (non-paid) Friday to decide if it needs to change the PTO rate. Currently we have to manually move this formula up or down a Monday depending which week we get paid. I feel like there should be a way to set it to be every 14 days from a certain date or something so it changes automatically when we change the year date. Is this possible? Can anybody please help me? Thank you in advance.
