Calculate date difference excluding weekend

Hi All,

I want to calculate date difference between 2 dates but excluding weekends. Thoughtspot has "IS_WEEKEND" function but that is applicable only when actual date is available. In my case while calculating the difference between the dates, I just want to include weekdays. e.g.

start date = 1/6/2020 

end date=30/6/2020 

Date Diff exclude weekends should be = 22 

Can anyone help on this please?

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 wk agoLast active
  • 11Views
  • 1 Following