How to group range of cells into date ranges of "Multiple times per day", Weekly, Monthly

I have a set of data that is shown as such:

User	Report	Month	Day
User 1	Report Name 1	2019 Aug	20/08/2019
User 2	Report Name 1	2019 Aug	20/08/2019
User 1	Report Name 2	2019 Aug	21/08/2019
User 2	Report Name 3	2019 Aug	23/08/2019
User 1	Report Name 1	2019 Aug	24/08/2019
User 3	Report Name 2	2019 Aug	30/08/2019
User 3	Report Name 4	2019 Aug	30/08/2019

I am trying to perform some research into how often certain reports are run and group them into the following ranges:

• Used multiple times a day
• Used once daily
• Used Weekly
• Used Monthly
• Used Yearly
• Seldom Used

I don't need to which users are using the reports, just the number. I've tried countifs but so far i've only been able to count the number of uses per day by creating a new table and de-duplicating the values like so:

Report	Month	Day
Report Name 1	2019 Aug	20/08/2019
Report Name 2	2019 Aug	21/08/2019
Report Name 3	2019 Aug	23/08/2019
Report Name 1	2019 Aug	24/08/2019
Report Name 2	2019 Aug	30/08/2019
Report Name 4	2019 Aug	30/08/2020

Then using Countif: =COUNTIFS(A3:A8,A3,C3:C8,C3)

This formula is only giving me how many uses of each report per date shown in column C. To know what is used daily I also need to eyeball column C and make a best guess that reports are being activated on consecutive days so it would be great if there was a way to factor in weekends and holidays into a formula.

Any help will be appreciated thanks!