And your planenddate for warehouseID4 is not matching with the one in blue. Using filters in excel check for warehouseid 4 and you can see planenddate in big table says 2/10/2017 and the one beside that it says 1/31/2017? Quite did not get if that is right.
Apart form that, i believe this is what you are looking for. Attaching the file.
Your dates look little off for me. Can you provide some revised version of your data, if this is not what you want.