So I need to create a metric report to determine if orders are shipping on time. I need to show if an order comes in BEFORE noon on a given day, then it needs to ship that day. If the order comes in AFTER noon then the date it needs to ship is the next day. I would like to have the calculated shipping day populate in a cell. I can go from there but I haven't seen anything applicable online on this. I think the INT function might work but I'm stuck. Thank you all for any help you can provide. I am using 2007
Bookmarks