Count Unique Dates If formula

I need to count unique dates in a list (column B) based on what period they are in(column A) . I have been able to do this with a pivot table, but really need a formula so that I can filter out rows if needed. A spreadsheet is attached to show an example of the data. I would greatly appreciate any help with this.

Thank you,
April

Is it possible for a date to be in two periods? At a quick glance, I did not see that occurring. So, would a COUNTIF() work for you?

Try this in cell C1 and drag down.
=COUNTIF($B$2:$B$1018,B2)

Pauley

If dates can be shared across periods, you should be able to use Domski's code from a previous thread you started. I modified it a bit so that it always returns the same number for a given date and period.

=SUMPRODUCT(--($A$2:$A$1018=A2),--($B$2:$B$1018=B2))

Pauley

{Hope we get some rain in Austin today}

Hi,
Attached the "Count Unique Dates" with formula and pivot table.
Hope this will help.
Best regards

Thank you both for your suggestions!!

Paulyb - Your second formula works well, but it is not quite what I am looking to do. So great that we got rain!

jpr73- Your formulas based on the pivot table works, but is it possible to make it simpler?

I have attached a spreadsheet with a pivot table that shows what I would like to do with a formula. The reason is that I want to be able to hide or filter out rows of data, so that they are not included in the count. I can't do that with the pivot table. Is it possible to translate this pivot into a formula? It just has to be as clean as possible and I am working with many tabs of data. I greatly appreciate your efforts in helping me with this!