Workday() function not working

I’m having problems with the WORKDAY() function.

My input is along the lines of WORKDAY([Start date];10;Holydays[Date]), but it tells me that “WORKDAY has invalid inputs”

The error goes away when I remove the Holydays[Date] input from the formula, but I have double-checked that all the dates are valid, and formatted as dates in both the google sheet and AppSheets

0 9 618
9 REPLIES 9
Top Labels in this Space