Formula to Display Notification LATE, EARLY, ON TIME

**Daryl10** · 04-12-2014, 07:19 AM

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

**RudiS** · 04-12-2014, 08:04 AM

Hi Daryl

Could you upload a small sample of your data so I can assist with the formula. It would be great if you can show a before and after of the results you expect so I can verify the calculation. It will help. TX

To upload a sample file, click on the Go Advanced button, bottom right and use the Adv Post Window, clicking on the paperclip button to upload and post a file. TX

**FDibbins** · 04-12-2014, 06:27 PM

Hi and welcome to the forum

This is untested, you did not provide any data, so give it a trty and adjust as needed...
A1=TODAY() (enter the function =TODAY() in A1)
A3 = Date of Arrival)

=if(A3<A1,"Early",if(A3<A1+7,"On Time","Late"))