| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT IF A DATE IS HIGHER THAN ANOTHER DATE
What formula will work to total the number of dates in column B that are
greater than the date in Cell A1. In the example below the answer will be 2. e.g. Cell A1 = 21/4/2008 Cell B1 = 2/1/2007 Cell B2 = 22/4/2008 Cell B3 = 17/8/2008 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT IF A DATE IS HIGHER THAN ANOTHER DATE
Modify to suit. Look in the help index for COUNTIF
=COUNTIF(D3:D6,""&D1) -- Don Guillett Microsoft MVP Excel SalesAid Software "Mally" wrote in message ... What formula will work to total the number of dates in column B that are greater than the date in Cell A1. In the example below the answer will be 2. e.g. Cell A1 = 21/4/2008 Cell B1 = 2/1/2007 Cell B2 = 22/4/2008 Cell B3 = 17/8/2008 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNT IF A DATE IS HIGHER THAN ANOTHER DATE
Thanks Don, that's great.
Its the part after the cell range I couldn't figure out. "Don Guillett" wrote: Modify to suit. Look in the help index for COUNTIF =COUNTIF(D3:D6,""&D1) -- Don Guillett Microsoft MVP Excel SalesAid Software "Mally" wrote in message ... What formula will work to total the number of dates in column B that are greater than the date in Cell A1. In the example below the answer will be 2. e.g. Cell A1 = 21/4/2008 Cell B1 = 2/1/2007 Cell B2 = 22/4/2008 Cell B3 = 17/8/2008 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count a record if it contains a date within a date range | Excel Worksheet Functions | |||
| count the mean in few date but on de date it has various data | Excel Worksheet Functions | |||
| count between start date and end date | Excel Discussion (Misc queries) | |||
| Count number of cells with date <today's date | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
Linear Mode
