View Single Post
  #1   Report Post  
Raymond Gallegos
 
Posts: n/a
Default Using Countif for Date Matches

Hello. I am trying to count the number of sales that occurred
in 2004 by using the following Countif formula
=COUNTIF(SalesForecast!D1:D4,year=2004), but all I get is 0, when
I thought I would get 1, which represented the sale for 2004.
Can anyone help?

Data
01/01/2003
03/15/2003
06/01/2004
09/30/2005