Between dates COUNTIF

[scottywalker]

Hi guys,

What I need is a formula that recognises 2 dates and counting how many of them there are.

E.g. On the example below, on the "dates received" column they are all in march, so I need a formula which counts all the dates between 01/03/2014 and 31/03/2014.

TIA

Ref Number	Opportunity	Date Received
1	ding	01/03/2014
2	dong	02/03/2014
3	bell	03/03/2014
4	the	04/03/2014
5	vicar	05/03/2014
6	is	06/03/2014
7	in	07/03/2014
8	the	08/03/2014
9	well	09/03/2014
10	who	10/03/2014
11	pushed	11/03/2014
12	him	12/03/2014
13	in	13/03/2014
14	and	14/03/2014
15	who	15/03/2014
16	pulled	16/03/2014
17	the	17/03/2014
18	poor	18/03/2014
19	vicar	19/03/2014
20	out	20/03/2014

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

 

[BrianMH]

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Ref Number	Opportunity	Date Received			From	To
2	1	ding	01/03/2014			01-Mar-2014	31-Mar-2014	20	*sumproduct no array
3	2	dong	02/03/2014
4	3	bell	03/03/2014					20	or if you just wanted to count dates in march *requires array
5	4	the	04/03/2014
6	5	vicar	05/03/2014
7	6	is	06/03/2014
8	7	in	07/03/2014
9	8	the	08/03/2014
10	9	well	09/03/2014
11	10	who	10/03/2014
12	11	pushed	11/03/2014
13	12	him	12/03/2014
14	13	in	13/03/2014
15	14	and	14/03/2014
16	15	who	15/03/2014
17	16	pulled	16/03/2014
18	17	the	17/03/2014
19	18	poor	18/03/2014
20	19	vicar	19/03/2014
21	20	out	20/03/2014
Sheet1

 

[scottywalker]

Hi,
Thanks for the reply but unfortunately additional columns will add complexity as the information goes back 4 years and this is meant to be a user friendly spreadsheet, not just for my personal use

 

[BrianMH]

OK. So clarify what you need and what my solutions do not provide.