Determing when an event occurs most frequently

Hello Everyone!

I have a list of data that is the day of the month(1-31) that an event has occurred. (sample data in attachment) I want to find some way to find when the "hottest" time of the month is when the events are occuring.

I am very open to suggestions as far as how to get the end result. I think for myself a chart of some sort would be good to see visually, or some kind of statistical breakdown.

My only requirement is that the list is always being added to, so the end result needs to be updating with the complete list.

Im not an expert in excel, so the more details on how to do this the better. Even better would be creating it in the attachment, and uploading your version so I can see exactly how you did it.
I am going to be taking this idea and apply it in the same way for day of week (1-7) and time of day.
Any ideas?
Thanks!!!!!!

Is that attachment data the day of the month that it occurred? Or am I missing something?

A pivot table would problem work.

So let's say Column A = Day of Month
Column B = Time of day it occurred

Is this only going to be tracked monthly or do you need a column for which month it is?

i used a COUNTIF formula. This will get you through your occurrence per day