View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cassidy1 Cassidy1 is offline
external usenet poster
 
Posts: 8
Default countif function using dates

I want to calculate the number of entries in a column that are later than one
date and earlier than another.
This is what I thought would work, but doesn't:
=COUNTIF(M3:M158,"30/09/2007"&"<01/11/2007")