Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Minimum Date Range from other cells | Excel Worksheet Functions | |||
Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
Test IF Two Numeric Values Match (from two separate Dynamic Ranges) | Excel Worksheet Functions | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Date Formatted Cells | Excel Worksheet Functions |