Counting occurrence of date in date range being string format

[miturand]

I have a date ranges as per below. one range per cell.

in the next column i have month and year from any of the below ranges. i.e Oct 2019
I need to count occurrence of of Oct 2019 in the third column in the row corresponding with the actual range, which is Oct - Dec 2019

Jan - Mar 2018

Apr - Jun 2018

Jul - Sept 2018

Oct - Dec 2018

Jan - Mar 2019

Apr - Jun 2019

Jul - Sept 2019

Oct - Dec 2019

Jan - Mar 2020

Apr - Jun 2020

Jul - Sept 2020

Oct - Dec 2020

<colgroup><col></colgroup><tbody>
</tbody>

I would prefer standard formula rather than array or macro if poss
any help?
Best Regards,
Tom

 

[admiral100]

Hi,

Could you please explain what you meant by the sentence "I need to count occurrence of of Oct 2019" ?
Do you want the column number ? What should be the result / answer?

 

[miturand]

in the third column i have values, i.e Oct 2019, May 2020, May 2019, etc. but they may repeat and i need to count occurrence. hope this make sense

 

[admiral100]

Please try to provide more explanation ...
What do you expect the result to be in cell C1?

	A	B	C
1	Jan - Mar 2018	Oct-19	?
2	Apr - Jun 2018	May-20
3	Jul - Sept 2018	May-19
4	Oct - Dec 2018	Apr-18
5	Jan - Mar 2019	Oct-19
6	Apr - Jun 2019	Oct-19
7	Jul - Sept 2019	Jan-20
8	Oct - Dec 2019	Feb-18
9	Jan - Mar 2020	Oct-18
10	Apr - Jun 2020	May-19
11	Jul - Sept 2020	Jul-19
12	Oct - Dec 2020	Apr-18

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>