Forum Discussion
Ravindu94
Jun 06, 2019Brass Contributor
Develop my formula dates
Here attached excel sheet with my next order date, date frequency and next delivery dates also in there. i need to amend formula if my next delivery date on Saturday , Should change it to last Friday (deduct a date) and if my next delivery date on Sunday , need to change it to next Monday (Increase a date) . Simply i need to deduct if my date shows Saturday and need to increase if shows it as Sunday .
- The formula you need in G2, copied down rows and across columns, is:
=$E2+$D2-
(WEEKDAY($E2+$D2)=7)+
(WEEKDAY($E2+$D2)=1)