Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif function
Good morning, I have a column with dates (MM/DD/YY) and I'm trying to write a
formula that will look at this column and tell me which ones are older than today. I tried =COUNTIF(B11:B396, "<TODAY()") which did not work. The only way I could get a result was =COUNTIF(B11:B396, "<01/19/10"). The problem with this is you have to enter today's date each time you open the file. Is there not an easier solution? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Function | Excel Worksheet Functions | |||
please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
countif function | Excel Worksheet Functions |