Counting number of rows where datediff of two columns meet criteria

[rmillman]

I have a range of data and need to summarize some of the data. In the table below is an example of the data. I would like to have a single formula where I can count the number of rows where the end date - start date is < 14 days. I would prefer not to add an additional column for the datediff value. Is there a way to do this with either arrays or named ranges?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Start
[/TD]
[TD]End
[/TD]
[TD]Other data
[/TD]
[/TR]
[TR]
[TD]Verizon
[/TD]
[TD]1/10/2010
[/TD]
[TD]1/25/2010
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AT&T
[/TD]
[TD]3/2/2010
[/TD]
[TD]4/14/2010
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[davesweep]

Hi,

Assuming that your data starts in A1,

=SUMPRODUCT(((C2:C8-B2:B8)<14)*(1))

or

=SUMPRODUCT(((C2:C8-B2:B8)<14)*((C2:C8-B2:B8)<>0)*(1))

to exlude rows where the difference is zero