counting cells containing certain ranges of dates

  • Thread starter Thread starter JRD
  • Start date Start date
J

JRD

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
 
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
 
Back
Top