I have a sheet with data organized by date for an entire year. Column "a" would be the dates in chronological order and column "b" would have a name in each cell. Many of the names are repeated throughout the year.

What formula would I use to count how many times a particular name was listed in column b within a particular month, quarter or date range of my choice?

I would like to create a new sheet to show this data once I have the proper formula/s.

I am using excel 2016