How to set the working days to Monday-Saturday?

Is there a way to change the business days to Monday-Saturday on When I hide weekends I want to hide only the Sunday. And the same will be considered when using formula.

Hey @donaldcornel, good question! At the moment the only options for business days are Monday-Friday or Sunday-Thursday.

Feel free to write to and we can see if there are any work arounds that would help given your use case.


This is because there are lots of companies in the Philippines having Mon-Sat working days. Hope there should be a flexibility on setting business hours and local holidays as well.

1 Like

Hi ,
I am having the same issue. We need this as well, as well as holidays (manuel set up woud be good as well). I am working a lot with functions and I was trying to somehow get it right.
WORKDAYS obv. doesnt work that well as Saturday isnt in it. Buy can you do someting like DAYS({Date1}, {Date2}) - SUNDAY (or anything like this?). Would be good to have every weekday set as a usable parameter (mon, tue, wed, thu, fri, sat, sun maybe).
Maybe even something like IF(Date.incl sun - 1).
Hope you can yet help us.