Hi
Thanks for taking the trouble to read this.
My question is that I need to calculate how long a delivery took to arrive at its destination. However it depends on when the order was placed. If the order was placed today before 5pm, I would use today as day 1. However if the order was placed today but after 5pm, I count tomorrow as day 1.
I'd thenn subtract the delivery date from the calculated day 1 date. I also have to ignore weekends and public holidays. I tried using NETWORKDAYS and a table of holiday date to reference, but I failed. I'm sure its simple. Can anyone help?
Thanks in advance.
Bookmarks