Forum Discussion

skv17's avatar
skv17
Helper II
2 years ago
Solved

Skip Weekends when adding date

I have two column - Start Date and Days required to deliver.   So if Start Date is 13/10/2023 which is on a friday and Days required to deliver is 2,so I need a new column called Arrival cut off da...
Need Help
Show and Tell
  • skv17's avatar
    skv17
    Helper II
    2 years ago

    Thank you so much!!!  this works ,

    one more question - how to a set another parameter in the same m query , where there is a column delivery days and its values are 

    Mon-Fri , Mon-Sat,Mon-Sun,Mon-Thu,  Tue-Sat .  and skip other days based on these parameters,
    So Mon-Sat - skip sunday , mon- thu - skip friday, saturday and sunday. 
    • Ahmedx's avatar
      Ahmedx
      Super User
      2 years ago

      I didn't quite understand you, show the expected result in Excel

      • skv17's avatar
        skv17
        Helper II
        2 years ago

        like the calculations that you have done was excluding weekends , so based on the delivery days column it is Mon-Fri,  so based on what I set a condition I set for the row value which i set in the backet SQL , that is if column value is x then Mon-Fri if column value is y then Mon-Sat

         

        So if Column value has Mon-Fri skip counting sat and sun , if Mon-Sat skip sunday