Forum Discussion
Excel
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 ...
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?
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
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?