Advance compare condition - compare number with a list of numbers
Humberto Gomes
Rising Star 
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Hi, community,
Do you know how to use this, adding a set (list of values)?
The idea is to get the day number and check if the number belongs to a list
Examples:
- day number = 45
- List = 1, 10, 20, 40, 50, 60
- Result = FALSE
- day number = 50
- List = 1, 10, 20, 40, 50, 60
- Result = TRUE
The final objective is to build a set of bank holidays and check if is a normal business day or not.
1 answer
1 accepted
Humberto Gomes
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Found the solution.
See bellow:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.