Select your column of date records, then use Data | Pivot table. Click
through to the end, then drag the date field button to both the row field
and the data field. Then use the Pivot Table button on the pivot table
commandbar, and choose group. Then select month or year, and you will get a
count of dates within each time period.

HTH,
Bernie
MS Excel MVP


"maxtrixx" wrote in message
...
I have a column with date records and I need to find out how many
records/month/year. can anyone help me? Thanks.