Excel

[MarkBeck54]

Hi

I have a calender which applies formatting to certain cells when applicable.

=MATCH(C15,Data!$H$2:$H$110,0)>0

which works fine until two dates collide

also if the date falls on a weekend will need to be moved to a Monday.

any ideas?

[#2]

@MarkBeck54 Would be helpful if you could show the context in which you use this formula. What's in C15, for instance and what in column H?

[#3]

@Riny_van_Eekelen 

Hi

Cell H is a list of dates ranging from 1/1/2020 - 1/1/2030

Cell C is also range of dates with the same criteria as per image this changes by 2 drop lists 

One is for Months the other is for Years

[#4]

@MarkBeck54 Not sure I follow. Looking at your screenshot and formula, C15 contains the number 26. H2:H110 contains day numbers for a number of Friday's, I presume. The formula looks if there is a number 26 somewhere in H2:H110 and returns an index number (from 1 to 109) if it is found or an #N/A error if not. And then you test if the number is greater than zero. What is it that you actually want to achieve?