Help

Removing weekends from DATETIME/DATEADD formula

Topic Labels: Formulas
1844 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Bri_Cieloha
4 - Data Explorer
4 - Data Explorer

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.