NETWORKDAY formula - calculating a half paid day off
I have a Paid Time Off (PTO) tracker in Smartsheet which utilizes the NETWORKDAY formula so the paid holidays won't affect the employee's PTO allotment.
NETWORKDAY([Start Date of PTO]@row, [Last Date of PTO]@row, DATE(2024, 1, 1), DATE(2024, 1, 15), DATE(2024, 5, 27), DATE(2024, 7, 4), DATE(2024, 9, 2), DATE(2024, 11, 28), DATE(2024, 12, 24), DATE(2024, 12, 25), DATE(2024, 12, 31)
Here's where I give up (go ahead and chuckle if it's super simple 😊): New Year's Eve (12/31) is only a HALF paid day. How do I get this formula to calculate the "DATE(2024, 12, 31)" portion of it as a half day (.5)?
If this screenshot doesn't help, please disregard (it is one out of dozens of failed attempts to manipulate it into doing what I want).
Thank you!
Best Answer
-
If 12/31 is the only day of concern, you could create a formula under PTO (Add Days Back, Subtract from Avail) which would yield 0.5 when days cover 12/31
Put this formula under PTO Add Back
=IF(AND([Start Date of PTO]@row <= DATE(2024, 12, 31), [End Date of PTO]@row >= DATE(2024, 12, 31)), 0.5, "")
Then just subtract the result from the PTO Days Requested in Adjust PTO Days column
Answers
-
If 12/31 is the only day of concern, you could create a formula under PTO (Add Days Back, Subtract from Avail) which would yield 0.5 when days cover 12/31
Put this formula under PTO Add Back
=IF(AND([Start Date of PTO]@row <= DATE(2024, 12, 31), [End Date of PTO]@row >= DATE(2024, 12, 31)), 0.5, "")
Then just subtract the result from the PTO Days Requested in Adjust PTO Days column
-
Thank you!!!! 😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!