| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count it - 13 Dec?
Does anyone have any suggestions on how to count it?
There is a list of date under column A, and I would like to count the number of date, which is not equal today, and return it in cell B1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to count it - 13 Dec?
Try this in B1:
=COUNTIF(A:A,"<"&TODAY()) On Dec 13, 12:55*am, Eric wrote: Does anyone have any suggestions on how to count it? There is a list of date under column A, and I would like to count the number of date, which is not equal today, and return it in cell B1. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Hybrid Mode
