Subtract two date colums and count rows with specific values

Originally Posted by waylynjohnston1

if cell C6 is changed to 3/29/16, I would expect cell G2 to change to 1. With the current formula, if cell C6 is changed to 3/2/16, cell G2 changes to #NUM!.

If G2 should change to 1, shouldn't G3 change to 2?

Try this...

=SUMPRODUCT(--(ABS(C$2:C$7-B$2:B$7)>=E2),--(ABS(C$2:C$7-B$2:B$7)<=F2))