Limiting Frequency formula to dates by month

[RtotheK]

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!

 

[Mike LH]

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))

 

[RtotheK]

Thank you, that seems to have done it.