Need to input a Range of Dates in a Formula

[lbc0056]

I am working on a project that calculates how often each of our vendors are "On Time" with their shipments. I need to figure out how to input a range of dates in a formula. For example "1/1/2014 through 3/31/2014". This is the formula I have now =COUNTIFS(E:E,"Vendor A",J:J,"Late",H:H,N5)

---

That refers to =COUNTIFS("Vendor Name Column","Vendor A","Early/On Time/Late Column","Late","Date Received Column",???)

---

How do I put a range of dates where the question mark is, so that it will pull any date in that range from the Date Received Column?

 

[TMShucks]

=COUNTIFS($E:$E,"Vendor A",$J:$J,"Late",$H:$H,">="&DATEVALUE("1/1/2014"), $H:$H,"<="&DATEVALUE("31/3/2014"))

or

=COUNTIFS($E:$E,"Vendor A",$J:$J,"Late",$H:$H,">="&DATE(2014,1,1), $H:$H,"<="&DATE(2014,3,31))

 

[lbc0056]

This is perfect. Thanks a lot

 

[TMShucks]

You're welcome.