How to exclude duplicates in a COUNTIFS formula

[Aurora_S]

Hi, I'm trying to count number of intake dates within a month but sometimes there will be mulitple intakes in one day so I just want to count each date once.
The data is part of a bigger spreadsheet which I can't change and contains data from previous and subsequent months.

In the sample extract, there's a drop-down cell B1 which gives the month to be calculated (this reads as August but is in 'mmmm' date format of 01/08/22)
My base formula is =COUNTIFS($A:$A,">="&$B$1,$A:$A,"<="&EOMONTH($B$1,0)) but obviously this will counts duplicate dates in the list which need to be excluded.

Thanks

 

[Fluff]

Hi & welcome to MrExcel.
How about =ROWS(UNIQUE(FILTER(A5:A1000,MONTH(A5:A1000)=MONTH(B1))))

 

[Aurora_S]

Hi & welcome to MrExcel.
How about =ROWS(UNIQUE(FILTER(A5:A1000,MONTH(A5:A1000)=MONTH(B1))))

Fabulous - thanks so much!
Initially I tried to use A:A in the formula (as there are thousands) and it didn't work but altered it to a row range and it worked perfectly. I hadn't realised it would make such a difference.

 

[Fluff]

You're welcome & thanks for the feedback.