Workday() function not working

Frederik
Participant V

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 584
9 REPLIES 9

hru
Participant V

How about:

WORKDAY([Start date],10,Holydays[Date])

That returns the same error

Hmmm…

is [Date] a date type?

Yes, it is

Double hmmm…

Do you have a Holydays table?

Yeah, my Holydays table is a simple table with two columns: [Date] and [Description]

I’m seeing the same issue. A manual list of dates works fine but any select function (e.g. SELECT, FILTER, Holidays[Date]) gives that error. I would report this to support@appsheet.com

I Agree. what else is there to ask?

It seems to be working wrongly. I will assign this to our devs for debugging. Thanks for this info!

Top Labels in this Space