View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
audreyglennette
 
Posts: n/a
Default Counting Cells with certain date ranges as values

I need to count cells withdates in theme in a column. So that would be a
CountA function; but only if the values in the cells are within a certain
date range, a COUNTIF function. Here's what I thought:
=COUNTIF('All Employees'!O1351:O1364,"12/31/05,<2/1/06")
It returns a zero, which I know is not correct, as I checked it on a smaller
sample.

What am I doing wrong?

I also tried a SumIF function, but because Excel works on the premise that
all dates are really number of days since the turn of the century (1900), it
returns a ridiculous number.