Hello!

I have a range of dates between 2008-02-25 till 2008-12-25 and I would like to
count the number of rows which has not empty data (distance field) for the
February 2008, March 2008 etc.

These data a
Date Distance (km)
2008-02-25 25 km
2008-02-26 26 km
2008-02-27 not filled in yet
2008-02-28 not filled in yet
2008-03-01 not filled in yet
etc. etc.

February 2008 - my functions should return 2
March 2008 - my function should return 0

Can you help me how to do it using Excel 2007 functions?

Thank you in advance
Martin