Hello everyone! I am new to the forum and consider myself to be a beginner in Excel functions. In my sheet i want a formula to figure out when an order is complete and whether it is On Time or Late. So if Total Order Qty, Planned Completion Date and a column which shows the total production which increases by the day is given, I want the sheet to automatically say in the status cell that the order is complete and whether it is on time or not.
suppose the total order qty is 20, Planned completion date is 10 july, Production Starts on 1st july, Daily production is 2 and so by the 10th july the order is complete.. In the Status it should say Complete and in another cell it should say On Time because it has completed on the planned date.
Possible?
Appreciate your help!
suppose the total order qty is 20, Planned completion date is 10 july, Production Starts on 1st july, Daily production is 2 and so by the 10th july the order is complete.. In the Status it should say Complete and in another cell it should say On Time because it has completed on the planned date.
Possible?
Appreciate your help!