JohnSlider
New Member
- Joined
- Nov 23, 2015
- Messages
- 41
If date formula equals Sunday, change to following Tuesday.
I have a complex formula where the end user enters a start date in one sell, and then can select lead times in either days or weeks (7 days) that eventually roll up to a final date.
The problem is that I can't have any of the middle, or the end, milestone(s) show up as a Saturday or a Sunday as those are not working days. So I need to add something that tells the formula that if a date calculates to a Saturday, then it will automatically move to the following Monday. If it calculates to a Sunday, then it will automatically move to the following Tuesday.
Does this make sense?
I have a complex formula where the end user enters a start date in one sell, and then can select lead times in either days or weeks (7 days) that eventually roll up to a final date.
The problem is that I can't have any of the middle, or the end, milestone(s) show up as a Saturday or a Sunday as those are not working days. So I need to add something that tells the formula that if a date calculates to a Saturday, then it will automatically move to the following Monday. If it calculates to a Sunday, then it will automatically move to the following Tuesday.
Does this make sense?