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

WAHOOO!!! It returned a 2. The correct answer! It worked! Once I understood
what you guys were saying to do. Thanks!
But now it has a new issue: I decided to test it by adding in some fake
entries (2/1/06, 2/2/06, and 1/2/06), so the answer should now be 3; it is
returning a 5. It's counting the other two Feb entries too?!

Here's what I have:
=COUNTIF('All Employees''
Training'!O1352:O1364,""&DATE(2005,12,31)-COUNTIF('All Employees''
Training'!O1352:O1364,"<"&DATE(2006,2,1)))