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

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.

Does this work for you?

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

Like a charm.Thanks!

1 Like