Well, you have the >= and <= operators so it should theoretically work... So unless something is wrong with the actual date entries in those ranges or something is not right in D:D or E:E then it is hard to tell without seeing it.

Can you post the workbook, first deleting unnecessary columns and changing around names, etc that shouldn't be seen?