If based on multiple criterias

Hi,

From a Delivery Priority, a Order Creation Date, and an Order Creation time, I am trying to get an expected good issue date with the criteria below:

Delivery Priority Urgent = Order Creation Date+1
Delivery Priority Standard AND Order Creation <18:00:00 = Order Creation Date+2
Delivery Prioirty Standard AND Order Creation >=18:00:00 = Order Creation Date+3


I am looking for a formula that groups all these criterias to return in Cell D2 the value needed.

Thanks for your help
Ben

Thanks, what would that give in the excel sheet with the cells.. etc.

I tried it but can't get any results.

Rgs