Count using entries within a range

[Morfi]

I want to use a formula to count the number of entries within a range of dates. I have a column in my worksheet called Date of Receipt (Column F). I want the formula to count the number of entries between 2 dates e.g. 01/04/2011-30/04/2011. How can I do this?

Also, I have another column where I record if a response has been sent out by a deadline (Column S). I would like to count how many responses were sent out on time within the same range of dates i.e. 01/04/2011-30/04/2011. How can I do this?

Column F = Date of receipt (entries in this column will range from 01/04/2011 until 30/06/2011)
Column S = Deadline met (entries in this column will either be Y or N)

My worksheet is called Apr-Jun and I want to use these formulas in a separate worksheet within the same workbook.

 

[jim may]

Sample of Counting records between dates... (only) - your 1st Q

Excel Workbook
	A	B	C	D
1	My Dates		Start Date>>>	6/1/2011
2	5/25/2011		End Date ===	6/30/2011
3	5/31/2011
4	6/1/2011		7	<< Record Count within Date Range
5	6/7/2011
6	6/13/2011
7	6/15/2011
8	6/18/2011
9	6/19/2011
10	6/25/2011
11	7/1/2011
12	7/7/2011
13	7/13/2011
14	7/19/2011
15	7/25/2011
16	7/31/2011
17	8/6/2011
18	8/10/2011
19	8/12/2011
20	8/18/2011
21	8/24/2011
22	8/30/2011
Sheet1

Excel 2007

Cell Formulas
Range	Formula
D2	=EOMONTH(D1,0)
C4	=COUNTIF($A:$A,">="&D1)-(COUNTIF($A:$A,">="&D2+1))

 

[CharlesChuckieCharles]

Try

=SUMPRODUCT((($A$4:$A$27>=$D$1)*($A$4:$A$27<=$D$2)),--(B4:B27="Y"))

counts the number of Y's in col B for a date range in col A

delimited by D1 start date
and d2 end date

 

[Morfi]

Thanks to you both. I think I have it working now!