|
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 |
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 |
| All times are GMT +1. The time now is 07:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com