Skip to main content

Hi all,

I’m trying to calculate a date based off the launch date that doesn’t exclude weekends (sat/sun) and holidays.

I’ve figured out this formula that works but it’s not excluding weekends. Is there a way to exclude weekend dates from this formula below?

DATETIME_FORMAT(DATEADD({Go-Live Date}, -8, ‘days’), ‘MM/DD/YY’)

Thanks in advance!
Bri

Welcome to the Airtable community!

I think you want the WORKDAY() formula function. It is documented in the Formula Field Reference.


Welcome to the Airtable community!

I think you want the WORKDAY() formula function. It is documented in the Formula Field Reference.


Hi @kuovonne thank you!