Thread: Countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
majestyk majestyk is offline
external usenet poster
 
Posts: 8
Default Countif

I need to count the occurences of dates between a range, either a week or
calendar month. I have so far:
=COUNTIF(Presentations,AND("="&"1/03/08","<="&"31/03/08"))
(**dates are dd/mm/yyy for Australia**). I keep getting an answer of 0 where
it should be 7.