Find all entries with specific month

[zxmod51]

Hello guys,

how can i find all records within a specific month? I have a Sheet with orders, where every order has a finishdate in column "H" from type Date.
I want to find now all orders, which are finished in month february for example and sum up a value which is located in column "L".
Is there a way with .find() and .findNext()? I could not find the entries, when i used find(what=CDate("02.2020")), it returned all dates
like 02.01.2020, 02.06.2020 and not the dates which are in february 2020.
I am relative new to excel vba.

Thanks guys!

 

[scoudny]

Hi zxmod51, you don't really need vba for this, you can filter by date with a filter dropdown.