A businessman take orders from a company XYZ and ships the product on
weekdays(Mon-Fri). New Orders come all 7 days of week and he ships
orders for Saturday and Sunday on Monday.
The shipping takes 2 working days to reach ABC's warehouse and no items reach at warehouse on Saturday and Sunday.
Write formulas for items arriving at warehouse for each day.
=IF(WEEKDAY(D4)=7,"-",IF(WEEKDAY(D4)=1,"-",IF(WEEKDAY(D4)=2,B5+C5+D5,D5)))
Drag it till right extreme end.
Formula for Arriving at warehouse
=IF(WEEKDAY(F4)=2,B6+C6,IF(WEEKDAY(F4)=4,D6,IF(WEEKDAY(F4)=5,D6,IF(WEEKDAY(F4)=6,D6,""))))
Drag it till right extreme end.
The shipping takes 2 working days to reach ABC's warehouse and no items reach at warehouse on Saturday and Sunday.
Write formulas for items arriving at warehouse for each day.
Answer:
Formula for Can't ship on Sat/Sun
=IF(WEEKDAY(D4)=7,"-",IF(WEEKDAY(D4)=1,"-",IF(WEEKDAY(D4)=2,B5+C5+D5,D5)))
Drag it till right extreme end.
Formula for Arriving at warehouse
=IF(WEEKDAY(F4)=2,B6+C6,IF(WEEKDAY(F4)=4,D6,IF(WEEKDAY(F4)=5,D6,IF(WEEKDAY(F4)=6,D6,""))))
Drag it till right extreme end.