Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Removing weekends from DATETIME/DATEADD formula

Topic Labels: Formulas
267 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

2 Replies 2

Welcome to the Airtable community!

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