count number of entries per week

[hibiscus27]

Hello

I have a log of the day and time each entry was received...I need to keep a running count of how many entries I recieve into the system, but i want to separate them per week. Then I need to graph those weekly totals....

How do I do that? Thanks!!!

~Zoe

[kraljb]

Pivot Table...

Dates as a column
Count instead of Sum
Group by 7 days starting at the beginning of a week.

[hibiscus27]

sorry kraljb....stupid question...what's a pivot table?

[hibiscus27]

Pivot Table...

Dates as a column
Count instead of Sum
Group by 7 days starting at the beginning of a week.

how do i group by 7 days?

[hibiscus27]

i assume i just double click and select group! the problem is that i keep getting error message: "Cannot group that selection"

I have no idea why!!!