Forum Discussion
Solved
struggle with WORKDAY function
Greetings all, I’m thinking this is an easy fix, but I’m not winning. When an order hits our system it gets a system datetime stamp. To calculate (Excel, 365) our service date, I need to adjust the o...
- Yes, that works perfectly! Although I am struggling to wrap my brain around WHY that works, seems like an system date of Sat would be interpreted as a Fri.... Not understanding, but yes, it works!! Thank you!
The idea is to go back one day, and then find the first working day after that.
If you start with a working day, you'll end up on that day again.
But if you start on Saturday, you go to Friday, and the first working day after that is Monday.
And if you start on Sunday, you go to Saturday, and the first working day after that is Monday.
Order system date One day before Next working date Monday Sunday Monday Tuesday Monday Tuesday Wednesday Tuesday Wednesday Thursday Wednesday Thursday Friday Thursday Friday Saturday Friday Monday Sunday Saturday Monday - Ohhhh! Yes, makes sense! Thank you!
