Forum Discussion
Imi_Jay
Jun 22, 2022Brass Contributor
Time array question
Hi , I need to look at the course start and end date. Then in a given month I want to find if the course was running. For a given month I want to find how many courses run. I tries countifs , w...
Mark_My_Words
Jun 23, 2022Copper Contributor
Hi Imi_Jay
Please check whether the following solution is helpful:
Formula in cell F2 is: =COUNTIFS($B$2:$B$28,"<="&EOMONTH(E2,0),$C$2:$C$28,">="&E2)
NOTE
1. Values in range E2:E14 are dates: 1-Jan-2021, 1-Feb-2021,1-Mar-2021 . . . 1-1-2022.
I applied Custom Formatting to make these dates appear as mmm-yyyy.
2. In the above suggested formula, please change cell reference/ranges to suit Your requirement.
3. Please drag the formula down to more rows.
Please respond if You require further assistance. I will try My best to be of help.
If I was able to help You, please Like My answer and mark it as the Best Response.
Thank You!