"davidm" wrote in message
...
I have a list of dates and wish to count the number of times February
appears. If I search for a specific date such as 03 February 2005 I have
no
problem but if I wish to find all values containing part of the cell, in
this
case the month, I become stuck.
Use the MONTH function in a different column to get the month. Use COUNTIF
to count the ocurrences of the month you're looking for.
/Fredrik
|