| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Cells with certain date ranges as values
Then your dates are not Excel dates but text so you can't really use a less
than condition Btw, the second formula should not return a ref error unless copied and pasted incorrectly, it should return zero since the dates are not numerical. To use the formulas you must use "real" dates that Excel understand as numbers in O1351:O1364 -- Regards, Peo Sjoblom http://nwexcelsolutions.com "audreyglennette" wrote in message ... This one returns a #VALUE! error: =COUNTIF('All Employees'!O1351:O1364,""&DATE(2005,12,31))-COUNTIF('All Employees'!O1351:O1364,"="&DATE(2006,2,1)) This one retuens a #REF! error: =SUMPRODUCT(--('All Employees'!O1351:O1364--"2005-12-31"),--('All Employees'!O1351:O1364<--"2006-02-01")) Any other ideas? Please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
