Date formula to exclude weekends

[Avidlearner]

I just wanted to know if it was possible to use more then one formula in a column? i.e., i need to find a day 6 days before set date, but also needs to exlude weekends, if that makes sense!

[rachitk]

Hi there,

Here’s the formula you can try to exclude the weekends:

  DATE_ADD(
   DATE_ADD({Date}, -6, 'days'),
   SWITCH(
      WEEKDAY(
         DATE_ADD({Date}, -6, 'days')
      ), 
      0, -1, 
      1, -2, 
      0
   ), 
   'days'
)

Here’s how the output will look like: