Hello,

Two suggestions:

1. You might get wrong results if you have more than 1 year old data
(MONTH(1/4/2009) = MONTH(1/4/2010)).

2. In addition to worksheet functions you might want to consider a VBA
approach or a Pivot table. Please see http://sulprobil.com/html/excel_newsgroups.html
for a comparison.

Regards,
Bernd