Question

complete the formula that's used to evaluate if a shipment is over 7 days late ,assuming that the date that the date ordered is is in cell d12

Answer 1

To evaluate if a shipment is over 7 days late based on the date ordered in cell D12, the formula can be completed as follows:

=IF(TODAY()-D12>7, "Shipment is over 7 days late", "Shipment is not over 7 days late")