Need to count data for specific week of month

[RumCakes]

Hope I explain this right, I'm just kind of fumbling my way through excel...
I track all the data that my team sends to their Leads. This is to assist our Leadership team to determine what topics we need to either have issues with or need better documentation in. Right now I can get excel to populate all the data for the complete year or for a specific month. But I now need to have it populate for the specific week of a month.

What my end goal is, is to select "March" for the month then "1st week" and it populates all the data from the March sheet from 3/2-3/8. Then select "2nd week" and it populates data for that. But to work for EACH month.
So if Month = January, and Week = 1st, then show data for first week... if I change the Month from January to April, leaving the week = 1st... then it would show the data from March 30th - April 5th.

Right now I have a very stupid long embarrassing IF statement to pull the data for the whole month. I don't understand/comprehend the Weeknum command or the ISOWeek command, and haven't found anything helpful.
My formulate currently is:
IF(D3="Jan",COUNTIF(Jan!:D:D,C22),IF(D3="Feb",COUNTIF(Feb!D:D,C22),etc,etc,etc.

What I think I'm looking for is:
IF(D3="Jan"AND(D4="1st Week"),COUNTIFS(Jan!A:A,WEEKNUM?????????,Jan!D:D,C22)

A:A=Date Column
D:D=Analyst
C22=Analyst


I know, I am making myself look stupid, but any help would be grateful.

 

[sksanjeev786]

Is this help you?

=IF(D3="Jan" AND D4="1st Week", COUNTIFS(Jan!A:A, WEEKNUM(Jan!A:A)=1, Jan!D:D, C22),