2) In C2, put ""= FLOOR(A2)"". This strips out the time and leaves the date, since the unit for date/times stored as numbers is one day.
3) In Column D, put a list of the dates you're interested in. (You can do this, e.g, by putting ""9/27/2009"" in D2, putting ""= D2 + 1"" in D3, and copying D3 down until you have enough days.)
4) In E2, put ""= COUNTIF(C:C, D2)"", and copy down for each of your days in Column D. This will count how many entries in Column C match each entry in Column D."
"This site explains how grouping can be easily done through a pivot table.
To group the items in a Date field
Right-click the Date field button. Choose Group and Show Detail | Group In the Grouping dialog box, select one or more options from the 'By' list. To limit the dates that are grouped, you can set a Start and End date, by typing the dates in the 'Starting at' and 'Ending at' boxes Click OK to close the dialog box."
