SOLVED

Develop my formula dates

Brass Contributor

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  .

3 Replies
best response confirmed by Ravindu94 (Brass Contributor)
Solution
The formula you need in G2, copied down rows and across columns, is:
=$E2+$D2-
(WEEKDAY($E2+$D2)=7)+
(WEEKDAY($E2+$D2)=1)

@Twifoo 

 

thank you. you are amazing man 

It's my pleasure to help you!
1 best response

Accepted Solutions
best response confirmed by Ravindu94 (Brass Contributor)
Solution
The formula you need in G2, copied down rows and across columns, is:
=$E2+$D2-
(WEEKDAY($E2+$D2)=7)+
(WEEKDAY($E2+$D2)=1)

View solution in original post