Skip to main content

Calculate a date a # of days before a date not including weekends

  • February 14, 2020
  • 2 replies
  • 26 views

Brite_Admin
Forum|alt.badge.img+11

I have a field called “Event Date” and I want to calculate 3 WORKDAYS before that event date. So if the event is on a Thursday, it will give me the date of the previous Monday but if the Event is on a Monday, it gives me the previous Wednesday as it ignores the weekend… I want to ignore the time.

Any help would be appreciated.

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+18

Does this work for you?

DATETIME_FORMAT(WORKDAY({Event Date}, -3),'l')

Brite_Admin
Forum|alt.badge.img+11
  • Author
  • Inspiring
  • February 14, 2020

Like a charm.Thanks!