Working Days subset

[Jo.Torres]

Hi all,

Is there any way to subset (in order to create a conditional) Working days vs non working days. I have a rough work around that can so weekends vs weekdays, but ideally would want to include bank holidays.
Thanks

[Jo.Torres]

Bump? This never got an answer, so I assume there isn’t a way to do this?
Currently using a work around of
IF DotW ‘Starts’ with S = Weekend
IF DotW ‘Doesn’t Start’ with S = Weekday

Not having public holidays is causing issues

[kevin.rowe]

I feel like there might be something you can do with the “count working days between 2 date fields” composite…

is it possible to do if(count working days between dateCreated and dateCreated = 1), then its not a bank holiday or a weekend, else it is a non-working day

or is it if(count working days between dateCreated and (dateCreated+1) = 1), then its not a bank holiday or a weekend, else it is a non working day

[kevin.rowe]

I think i might have a solution for a given date:

composite 1: given date minus 1 day

composite 2: working days between 2 date fields (from composite 1 to given date)

if composite 2 = 1 then its a working day
if composite 2 = 0, then its a non working day

[kevin.rowe]