I could really use some help!
I want my formula to return the correct Ship Deadline taking into consideration the time the order was submitted. If it came in before 4:00 pm on a weekday, it needs to ship the next day. If it came in after 4:00 pm on a weekday, it needs to ship in 2 weekdays.
This screenshot shows that order 5014021 came in at 5:15 pm correctly shows it needs to ship 2 weekdays later. But for some reason, order 5014020 that came in at 7:15 pm on the same date is showing it needs to ship in 3 days instead.
I can’t for the life of me figure out what I am doing wrong. Formulas are not my strong suit so I use AI to help write them. Any advice here would be very much appreciated. It will be so awesome if I can get this to work with anyone’s help!
My formula:
IF(
{Store Name} = "Retail",
IF(
OR(WEEKDAY({Created (DEV)}) = 6, WEEKDAY({Created (DEV)}) = 0),
IF(
WEEKDAY({Created (DEV)}) = 6,
WORKDAY({Created (DEV)}, 1),
WORKDAY({Created (DEV)}, 2)
),
IF(
VALUE(DATETIME_FORMAT({Created (DEV)}, "H")) < 16,
WORKDAY({Created (DEV)}, 1),
WORKDAY({Created (DEV)}, 2)
)
),
IF(
{Store Name} = "Moodcast",
IF(
OR(WEEKDAY({Created (DEV)}) = 6, WEEKDAY({Created (DEV)}) = 0),
WORKDAY({Created (DEV)}, 4),
IF(
VALUE(DATETIME_FORMAT({Created (DEV)}, "H")) < 16,
WORKDAY({Created (DEV)}, 3),
WORKDAY({Created (DEV)}, 4)
)
)
)
)
