Use a SUMPRODUCT

=SUMPRODUCT(--(MONTH($C$3:$C$46)=F3))

Where C3:C46 is your range of dates. The month function will give you the
month value as 1-12. F3 is a cell that just says 1. Presumably, you'd have
cells F3-F15 to show values of 1-12. Copy the formula down and it will give
you the count of entries from January-December
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"elwyn" wrote:

In column A I have a series of dates using the format dd-mmm. Can I use a
formula that counts the number of dates in Jan for instance and then changes
to count the number of dates in Feb and so on throughout the year?

Thanks for any help