| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
COUNTIF < DATE with other data in column
Hi
I want to count the dates in a column that are less than today, so i am using: =COUNTIF('AM Live'!H:H,"<="&TODAY()) But this returns the wrong value. In column H is other data than dates and think this is causing the error. At the moment it returns 88 but there are only 9 or so less than today??? Thanks John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent Hidden Column data from being copied/pasted? | Excel Discussion (Misc queries) | |||
| How do I restrict data movement (cut & paste) to only one column? | Excel Discussion (Misc queries) | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
| Matching data in one column to another | Excel Worksheet Functions | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Linear Mode
