How to use match with date

[forginganewone]

how to use date as criteria for example i have FEB-18 written in cell A1 i want it to search column L and find any dates in Feb-18.

I just need the criteria format so that i can use in any formula such as Match,countif,sumif

 

[fhqwgads]

maybe something like this?

Feb-18
5/02/2018
date falls in this month

formula in the third cell is

=IF(DATE(YEAR(A1),MONTH(A1),1)=DATE(YEAR(A2),MONTH(A2),1),"date falls in this month",0)

assuming A1 is a cell with a date

 

[forginganewone]

maybe something like this?

Feb-18
5/02/2018
date falls in this month

formula in the third cell is

=IF(DATE(YEAR(A1),MONTH(A1),1)=DATE(YEAR(A2),MONTH(A2),1),"date falls in this month",0)

assuming A1 is a cell with a date

The problem is i have to search in an array not a single.
Please find sample data here : https://expirebox.com/download/c6f2e65cb2b6f270a4904157c72ee247.html