DEV Community

mary kariuki
mary kariuki

Posted on

THE ORDER IS LATE AGAIN???

How many times have you lost that sale, reason? you are too busy to keep date trails on all the orders pending and their required dates.

with just an excel sheet you can calculate your lead time and sort from urgent to less urgent orders.

This how you calculate the Lead time

=IF(OrderDate>RequiredDate, "Late", DATEDIF(OrderDate, RequiredDate, "d"))
Enter fullscreen mode Exit fullscreen mode

`

Top comments (0)