| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
I meant to say "with a value of 38,456 or less"
Jason -----Original Message----- Dates are nothing more than numbers in Excel, so any cell in col. H with a value of 38,456 (which equates to April 14, 2005) will be counted in your formula. You need to somehow distinguish actual dates from ordinary numbers in your column. To learn more about date/time in XL, see: http://www.cpearson.com/excel/datetime.htm#SerialDates HTH Jason Atlanta, GA -----Original Message----- 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 . . |
| 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 | |||
Threaded Mode
