If DATE is part of LIST Then

[genji]

Hi

After reading, searching, breaking my head... I still couldn't find a solution for what seems a quite easy thing in the first place.
I want to check if a cell has a certain colour. If so, it needs to cehck if the date linked to this cell is part of an array of bank holidays.
If that's also true, a counter must count + 1.

Unfortunately, I feel like missing a serious basic view on the problem, because it simply won't work.
Is there anyone who can get me on the correct way please?

The code I ended up after multiple if x = a comparisons is the following (checking if dateserial(1 JAN 2020) = dateserial(1 JAN 2020)).
This gives no error, but the counter stays at 0. So at this moment it doens't make sense to cehck the whole array BankHolidays for the date 1 JAN 2020 to be part of it.

Please Login or Register  to view this content.

Many many many thanks for the one who can help me out here.

[AlphaFrog]

Please Login or Register  to view this content.

[Crooza]

Hi and Welcome

Maybe this will work for you

Please Login or Register  to view this content.