Hi,

You could use a pivot table for this with the Date field in the Row area and
as a count in the Data area. Then group the row area by month and year.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"George Gee" wrote:

Column A is a list of dates with the format 01/01/2000, 30/04/2001 etc.
How would I count the number of occurrences of dates in column A
for the month of say January 2000

How would I count the number of occurrences of dates for the year 2000

Great If you can help.

George Gee