Countif for Date Counts with Weeknumber and specific month

It's not clear what the expected results are.

I recommend including some of the desired results manually then re-uploading your sample.

Thank you so much for your quick reply. I have edited my thread along with new attachment.

Put this in B2:
=WEEKNUM(A2)
Drag the formula down column B

Then you can use this:
=COUNTIFS(A:A,">="&DATE(2019,9,1),A:A,"<"&DATE(2019,10,1),B:B,37)

See attachment.

Thanks a lot. I have the limitation that I cannot add any additional column in the sheet. What I can do that I can copy that entire sheet in a new workbook and then apply the formula you have provided. Is there any specific formula by which I can copy an entire sheet from one workbook and paste the same in another workbook.

Maybe just right-click on the Date & Result worksheet > Move or Copy > check the "Create a copy" box and tell it where to go > OK

Or just copy/paste into a new workbook.

Thank you so much. That's really a great help

You're welcome. Happy to help.