I am trying to calculate date due using WORKDAYS as follows: =WORKDAY([Timestamp], 3, Holidays[Date]), where ‘Holidays[Date]’ points to a column in the Holidays table that specifies holidays to exclude in the calculation. Appsheet is not liking the ‘Holidays’ variable. How can I work around this problem?
Ed_Benet (Ed Benet) #1
tony (Tony Fader) #2
+Freedom Lover The AppSheet WORKDAY formula doesn’t allow you to include a list of holidays…
…but I’ll add that. Let me get back to you.
Ed_Benet (Ed Benet) #3
tony (Tony Fader) #4
+Freedom Lover Okay, it should go out on Monday.