How to recognize date change to calculate averages

[woodswanderer]

I have a set of daily data ranging from 1990-2010. Each day, a number of data points are recorded. The number of data points collected, however, are not consistent. For example, sometimes nine points are collected/ day; sometimes three points/day, sometimes one point/day, etc. I need to calculate a daily average for each day. Is there a way to program Excel to recognize the date change so that it will create an average for each day? Thanks in advance. An example of the data layout is below (in columns A, B and C):

Date Time Data
1-Jan-90 2:34 0.196
1-Jan-90 5:34 0.205
1-Jan-90 7:34 0.208
1-Jan-90 8:34 0.208
1-Jan-90 11:34 0.208
1-Jan-90 14:34 0.211
1-Jan-90 17:33 0.227
1-Jan-90 20:34 0.227
1-Jan-90 23:34 0.23
2-Jan-90 2:34 0.23
2-Jan-90 5:34 0.23
2-Jan-90 7:34 0.227
2-Jan-90 8:34 0.227
2-Jan-90 11:34 0.23
2-Jan-90 14:34 0.23
2-Jan-90 17:34 0.227
2-Jan-90 20:34 0.224
2-Jan-90 23:34 0.22
3-Jan-90 2:34 0.22
3-Jan-90 5:34 0.217
3-Jan-90 7:34 0.217
3-Jan-90 8:33 0.217
3-Jan-90 11:34 0.214
3-Jan-90 14:34 0.214
3-Jan-90 17:34 0.214
3-Jan-90 20:34 0.211
3-Jan-90 23:34 0.211

[Palmetto]

Create a dynamic named range for the database and base a Pivot Table on the named range. Set Date as a row field in the Pivot Table and group the dates. Set the data field to Average (it may default to Sum).

When you add new data, the dynamic named range will automatically expand to include the new entries.
To update the Pivot Table with the new data, right-click on the Pivot Table and choose Refresh.

Help on Dynamic Named Ranges
Using Pivot Tables and Pivot Charts in Microsoft Excel

[contaminated]

Try to use Pivot Tables. Must help
Related tutorial

[woodswanderer]

Simple enough. Thanks. It worked.