I am trying to calculate date due using WORKD...

(Ed Benet) #1

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?

(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) #3

Thanks!

(Tony Fader) #4

+Freedom Lover Okay, it should go out on Monday.