|OK, that makes even less sense.|
e.g. Date in cell is 7/15/2016
7/15/2016 "equals or is less than the date 07/31/2016", so the result should be "Over Retained"
7/15/2016 is also "greater than 07/01/2016" so the result should be "Not Over Retained"
Sorry, but you can't have it both ways. ;-)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.