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

[TABLE="width: 254"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Ref Number[/TD]
[TD]Opportunity[/TD]
[TD]Date Received[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ding[/TD]
[TD="align: right"]01/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]dong[/TD]
[TD="align: right"]02/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]bell[/TD]
[TD="align: right"]03/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]the[/TD]
[TD="align: right"]04/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]vicar[/TD]
[TD="align: right"]05/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]is[/TD]
[TD="align: right"]06/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]in[/TD]
[TD="align: right"]07/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]the[/TD]
[TD="align: right"]08/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD]well[/TD]
[TD="align: right"]09/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD]who[/TD]
[TD="align: right"]10/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD]pushed[/TD]
[TD="align: right"]11/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD]him[/TD]
[TD="align: right"]12/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD]in[/TD]
[TD="align: right"]13/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD]and[/TD]
[TD="align: right"]14/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD]who[/TD]
[TD="align: right"]15/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD]pulled[/TD]
[TD="align: right"]16/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD]the[/TD]
[TD="align: right"]17/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD]poor[/TD]
[TD="align: right"]18/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD]vicar[/TD]
[TD="align: right"]19/03/2014[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]out[/TD]
[TD="align: right"]20/03/2014[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.