I have set up a chart that shows the day my product starts production, the day it goes in QC and the day it ships to our warehouse. I would like to create a column that shows what “stage” my order is currently in. I need a formula that will look at today, look at the dates in each column and then if it is between certain dates write the stage. If it is less than the start date writes “Not yet in production” and if it is past the arrival date write “PO closed”.
Can anyone help?