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

[Brite_Admin]

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.

[Jeremy_Oglesby]

Does this work for you?

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

[Brite_Admin]

Like a charm.Thanks!