Hello ,

I want to make a report that would auto display a status if a certain shipment is cleared with customs late, early or on time. Can somebody kindly help me out with this formula? I only have the data for the date shipped, the date of arrival, but the condition is if the shipment is not yet arrived then it would be tagged as EARLY, if it is cleared within 7 days it is considered ON TIME, if more than 7 days it is considered LATE.

Please help.

Thanks,

Daryl