Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

1256 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Brite_Admin
7 - App Architect
7 - App Architect

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.

2 Replies 2

Does this work for you?

DATETIME_FORMAT(WORKDAY({Event Date}, -3),'l')
Brite_Admin
7 - App Architect
7 - App Architect

Like a charm.Thanks!