Hi, I would like to know if there is a formula that could to create a date by looking for the highest date with the same criteria and then adding 1 day to it to make it greater. For example, in the below table I want the last row in Col E to look at item 932 and see that 11/3/2019 is the highest date, then make the last cell in Col E 11/4/2019. Also, for 2972, I want the last row for that item to look at 2/23/2019, and make it 2/24/2019.
|Col A||Col B||Col C||Col D||Col E||Col F|
|Item No.||CUR STK||Projected Stock||Machine||Start Date||Mach Run Qty|