Hi All,

can someone help me with the following issue:

I have a field called orderdate: this is the date when the order is received.

i have fixed shipping days (like monday/wednesday), depending on the country.

example:

Orderdate          Country      Planned Shipdate
09-20-2010         DK                  ??
09-21-2010         DK                  ??
09-20-2010         BE                  ??

for country DK, we ship on monday and wednesday.

what kind of formula do i need, to decide the first available monday or wednesday for
the planned shipped date?

same day shipment is not the case and in the weekends there are no shipments.

any help is appreciated.

regards,
Memoli