Need to determine the stage of a house by the dates submitted

Robert S Fike
Robert S Fike ✭✭✭✭

Our builders submit dates at each critical stage. I need to write a formula to show what stage the house is in by the looking at the latest date submitted. Any thoughts to what function i should use.

image.png


Trying to give the last column "Stage of Job", an answer of Slab, Frame, Cabinets or Final CO, based on the latest date entered.

Best Answer

Answers