counting cells containing certain ranges of dates

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
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to find the most recent date in a column based on other column 7
Counting cells with specific month in 7
How do I get the date for the 2nd friday of each month? 8
Counting once more 2
Looking up a maximum value that matches criteria. VLOOKUP? 4
may be SP! 5
Picking out a Period, in relation to certain cells 6
COUNTIF headscratcher 6

Top