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!


Reply