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...
admin
developer
excel
Excel Online
Formulas and Functions
Macros and VBA
office 365
training
  • Twifoo's avatar
    Twifoo
    Jun 06, 2019
    The formula you need in G2, copied down rows and across columns, is:
    =$E2+$D2-
    (WEEKDAY($E2+$D2)=7)+
    (WEEKDAY($E2+$D2)=1)
Twifoo's avatar
Twifoo
Silver Contributor
Jun 06, 2019
The formula you need in G2, copied down rows and across columns, is:
=$E2+$D2-
(WEEKDAY($E2+$D2)=7)+
(WEEKDAY($E2+$D2)=1)
  • Ravindu94's avatar
    Ravindu94
    Brass Contributor
    Jun 06, 2019

    Twifoo 

     

    thank you. you are amazing man 

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Jun 06, 2019
      It's my pleasure to help you!