formula for mrp orders exception status

hi community

im working on a school project for my major in supply chain

one of the projects i would like to perform its a excel file that shows exception status for the current orders in place

for example, we have demand to cover an order by March 5 but the next order arrives on March 23, the system should provide a message that says to push in the order to March 5

my knowledge in excel its pretty steep but i know formulas like vlookup, nested if, that sort of stuff