MRomanow
03-10-2005, 07:51 AM
Here is my problem:
I have an Order Date. I am trying to generate a Ship Date based on this Order Date. If the Order Date is Mon-Thur, the formula would just be Order Date + 1. However, if the Order Date is a Fri, it is Order Date +3; Sat, it is Order Date +2; Sun, it is Order Date +1.
=IF(WEEKDAY(L2,2)=6,L10+3)
So basically I want to incorporate three things into the formula:
If Order Date = 6 (Fri), Order Date +3
" " = 7 (Sat), Order Date +2
" " = 1 (Sun), Order Date +1
If Order Date = 2 (Mon),3(Tue),4(Wed),or 5(Thu), Order Date + 1
Any suggestions on how to accomplish this? I can do three different formulas but I was trying to see if I could do it all together.
Thanks
I have an Order Date. I am trying to generate a Ship Date based on this Order Date. If the Order Date is Mon-Thur, the formula would just be Order Date + 1. However, if the Order Date is a Fri, it is Order Date +3; Sat, it is Order Date +2; Sun, it is Order Date +1.
=IF(WEEKDAY(L2,2)=6,L10+3)
So basically I want to incorporate three things into the formula:
If Order Date = 6 (Fri), Order Date +3
" " = 7 (Sat), Order Date +2
" " = 1 (Sun), Order Date +1
If Order Date = 2 (Mon),3(Tue),4(Wed),or 5(Thu), Order Date + 1
Any suggestions on how to accomplish this? I can do three different formulas but I was trying to see if I could do it all together.
Thanks