| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
countif(a1:a12,">TODAY()") How do I get this to work?
Have a column of dates and I want to count the number of dates in the column
that are greater than today's date. Tried using the countif function as above to no avail. Is there another function to use or a way to change how I am specifying the criteria? Dan |
|
#2
|
|||
|
|||
|
=COUNTIF(A1:A12,""&TODAY())
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Dan Bork" wrote in message ... Have a column of dates and I want to count the number of dates in the column that are greater than today's date. Tried using the countif function as above to no avail. Is there another function to use or a way to change how I am specifying the criteria? Dan --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.789 / Virus Database: 534 - Release Date: 07/11/2004 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Service work order | Charts and Charting in Excel | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
| Lookup Doesn't Work | Excel Worksheet Functions | |||
| The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions | |||
| How do I ensure dates inputted are during the work week? | Excel Worksheet Functions | |||
Linear Mode
