I had tried that prior to posting, but for some reason it returns 0. I have 9 dates in column E that have a date between 11/11/2014 to 11/18/2014 so the formula should return a 9.