View Single Post
  #2   Report Post  
Fredrik Wahlgren
 
Posts: n/a
Default


"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