Count number of rows with same date so it can be charted.

[MSKNJAjoshua12]

I have a table that list network events by day. If 10 events occur on Monday, 10 on Tuesday, 5 on Wednesday, etc. I am trying to get the count for each day so I can create a pivot table/chart (like a control chart) showing the flow of events over time. The problem is the date field (column D) seems to include the time stamp when I create the pivot table and in the chart it ends up showing a column for every single event instead of showing the total count per day. If I add a column to strip off the time stamp e.g Left(D2,5) it gives me the decimal representation of the date so my pivot table and chart show the decimal number instead of the actual date. I just want a count of events per day so I can chart it. - Thanks in advance for any solutions.

The expected output would be a column that shows the count of events for each day.

[dilipandey]

Hello and welcome to the forum.

Please upload a sample workbook along with your expected output. thanks.


Regards,
DILIPandey
<click on below * if this helps>

[Jacc]

Have you tried formatting the extra column as date?