Forum Discussion

Ravindu94's avatar
Ravindu94
Brass Contributor
Jun 06, 2019
Solved

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)

3 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    The formula you need in G2, copied down rows and across columns, is:
    =$E2+$D2-
    (WEEKDAY($E2+$D2)=7)+
    (WEEKDAY($E2+$D2)=1)