Currently I have a COUNTSIFS formula that I would like to add an additional element to:
What I have been trying to add is if the date does not exceed or equal to the first date of a specified month it would display nothing. I am creating a date grid with colored conditional formatting and the easiest way it seems to not display a color is if the value return is nothing. Otherwise I would need to go into each individual cell and create a DATE check and stopping the conditional formula if true.
I've tried adding an if statement and nesting the countifs and that would not work, I tried adding a specific criteria in the first part of the countifs, and nothing.
Code:
=COUNTIFS('events Report'!$C:$C,">=1/1/2017",'events Report'!$C:$C,"<=1/31/2017",'events Report'!$F:$F,B38)
What I have been trying to add is if the date does not exceed or equal to the first date of a specified month it would display nothing. I am creating a date grid with colored conditional formatting and the easiest way it seems to not display a color is if the value return is nothing. Otherwise I would need to go into each individual cell and create a DATE check and stopping the conditional formula if true.
I've tried adding an if statement and nesting the countifs and that would not work, I tried adding a specific criteria in the first part of the countifs, and nothing.