# Limiting Frequency formula to dates by month

#### RtotheK

##### New Member
Hello all,

I've done a lot of searching and can't find a way to achieve what I'm after, so grateful for assistance.

The important info on my spreadsheet:
- Staff names in 'Daily Stats'!A3 onward
- Dates in 'Daily Stats'!B3 onward (in date format)

I am looking for a way to count the number of unique days on which a staff member made an entry on the sheet, and (this is the difficulty) be able to count this just for a specific month.

At the moment I have this formula, which is giving me the count of unique days for staff (in this example the staff name is in 'Team Report'!B2). How would I make this only count entries with dates in a specific month, eg only January?

=SUM(IF(FREQUENCY(IF('Daily Stats'!\$A\$3:\$A\$90000='Team Report'!\$B2,'Daily Stats'!\$B\$3:\$B\$90000),'Daily Stats'!\$B\$3:\$B\$90000),1))

Would prefer to avoid enabling macros on this sheet.

Thanks!

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Hi,

Try this which is for january

=SUM(IF(FREQUENCY(IF('Daily Stats'!\$A\$3:\$A\$90000='Team Report'!\$B2,IF(MONTH('Daily Stats'!\$B\$3:\$B\$90000)=1,'Daily Stats'!\$B\$3:\$B\$90000)),'Daily Stats'!\$B\$3:\$B\$90000),1))

Thank you, that seems to have done it.

Replies
1
Views
981
Replies
22
Views
2K
Replies
6
Views
800
Replies
0
Views
564
Replies
4
Views
311

### Forum statistics

1,196,462
Messages
6,015,385
Members
441,889
Latest member
balolaptopgiaolong

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back