# Countif for Date Counts with Weeknumber and specific month

1. ## Countif for Date Counts with Weeknumber and specific month

I have an excel sheet where I want to count dates appearing in a particular month and a particular week of that month. I have to use Countifs formula. Sample sheet attached. Please assist. For example, in September, 2019, I have count of dates 16 but the count of dates in September's 37th week is 7. I want the result to be 7 through countif(s)

2. ## Re: 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.

3. ## Re: Countif for Date Counts with Weeknumber and specific month

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

4. ## Re: Countif for Date Counts with Weeknumber and specific month

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.

5. ## Re: Countif for Date Counts with Weeknumber and specific month

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.

6. ## Re: Countif for Date Counts with Weeknumber and specific month

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.

7. ## Re: Countif for Date Counts with Weeknumber and specific month

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

8. ## Re: Countif for Date Counts with Weeknumber and specific month

You're welcome. Happy to help.

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1