tati69angel
New Member
- Joined
- Aug 6, 2010
- Messages
- 5
Hello:
Any help with this would be greatly appreciated. I need help with rounding a due to date to the earliest friday. For example:
If order is received on 6/24/10 (A4) then confirmation must be sent out within ten days
A4 + 10= 7/4/10. The 4th is a saturday.
However, if the result is a saturday or sunday, it needs to be rounded to the Friday before.
I also need to subtract in the same manner.
Ie: if due date is 11/1/10 then reminder letters must be sent out 15 days before.
A4-15 = 10/17/10 which is a sunday and needs to become Friday.
Please help. thank you so much.
<!-- / message -->
Any help with this would be greatly appreciated. I need help with rounding a due to date to the earliest friday. For example:
If order is received on 6/24/10 (A4) then confirmation must be sent out within ten days
A4 + 10= 7/4/10. The 4th is a saturday.
However, if the result is a saturday or sunday, it needs to be rounded to the Friday before.
I also need to subtract in the same manner.
Ie: if due date is 11/1/10 then reminder letters must be sent out 15 days before.
A4-15 = 10/17/10 which is a sunday and needs to become Friday.
Please help. thank you so much.
<!-- / message -->