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

[TABLE="width: 114"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Jan - Mar 2018[/TD]
[/TR]
[TR]
[TD]Apr - Jun 2018[/TD]
[/TR]
[TR]
[TD]Jul - Sept 2018[/TD]
[/TR]
[TR]
[TD]Oct - Dec 2018[/TD]
[/TR]
[TR]
[TD]Jan - Mar 2019[/TD]
[/TR]
[TR]
[TD]Apr - Jun 2019[/TD]
[/TR]
[TR]
[TD]Jul - Sept 2019[/TD]
[/TR]
[TR]
[TD]Oct - Dec 2019[/TD]
[/TR]
[TR]
[TD]Jan - Mar 2020[/TD]
[/TR]
[TR]
[TD]Apr - Jun 2020[/TD]
[/TR]
[TR]
[TD]Jul - Sept 2020[/TD]
[/TR]
[TR]
[TD]Oct - Dec 2020[/TD]
[/TR]
</tbody>[/TABLE]

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?


[TABLE="width: 316"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD] [/TD]
[TD] A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Jan - Mar 2018[/TD]
[TD]Oct-19[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Apr - Jun 2018[/TD]
[TD]May-20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Jul - Sept 2018[/TD]
[TD]May-19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Oct - Dec 2018[/TD]
[TD]Apr-18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Jan - Mar 2019[/TD]
[TD]Oct-19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Apr - Jun 2019[/TD]
[TD]Oct-19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Jul - Sept 2019[/TD]
[TD]Jan-20[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Oct - Dec 2019[/TD]
[TD]Feb-18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Jan - Mar 2020[/TD]
[TD]Oct-18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Apr - Jun 2020[/TD]
[TD]May-19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]Jul - Sept 2020[/TD]
[TD]Jul-19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]Oct - Dec 2020[/TD]
[TD]Apr-18[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]