| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting cells containing certain ranges of dates
How do I count the number of cells in a column that contain an entry between
certain dates. Note, that the entries are in a date format so that although the entry in the cells is as below, in the data entry box above the worksheet, 01 October 2006 appears 01/10/2006. So for example how do I count the cells below between October 1st and October 2nd - answer: 4 Date of procedure 01 October 2006 02 October 2006 02 October 2006 02 October 2006 03 October 2006 03 October 2006 03 October 2006 Thanks John |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting cells containing certain ranges of dates
Hi,
Maybe =COUNTIF(A1:A20,"="&B1)-COUNTIF(A1:A20,"="&C1) With you date in column A and where B1 contains your earlier date and C1 the latter Mike "JRD" wrote: How do I count the number of cells in a column that contain an entry between certain dates. Note, that the entries are in a date format so that although the entry in the cells is as below, in the data entry box above the worksheet, 01 October 2006 appears 01/10/2006. So for example how do I count the cells below between October 1st and October 2nd - answer: 4 Date of procedure 01 October 2006 02 October 2006 02 October 2006 02 October 2006 03 October 2006 03 October 2006 03 October 2006 Thanks John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells between ranges | Excel Discussion (Misc queries) | |||
| counting valid dates in a range of cells | Excel Worksheet Functions | |||
| Counting Cells with certain date ranges as values | Excel Worksheet Functions | |||
| How do I count cells in a column of dates between date ranges? | Excel Worksheet Functions | |||
| Counting the number cells between two dates | Excel Discussion (Misc queries) | |||
Hybrid Mode
