SUMPRODUCT includes comparison of date ranges in two columns and equating it to a constant

Try this formula. I am getting 1 for this in your sheet.

Formula:

=SUMPRODUCT(--((B2:B6-A2:A6)=3),--(B2:B6<>0),--(C2:C6="1 - Urgent"))