A pivot table grouping the dates by month would be perfect for doing this.

Dom