Estimated Delivery: WORKDAY + Region Lead-Time + Holidays

You're an operations analyst computing estimated delivery dates for 12 orders. Each order has an order date (column B), a destination region (column C), and the carrier's lead time depends on the region:

The carrier honors a fixed holiday list at F2:F5 — orders that would otherwise land on a holiday push to the next business day. Weekends (Sat/Sun) are also skipped by default.

Worked example: an APAC order on 2026-05-20 (Wed) with a 7-business-day lead time. Without any holidays, counting forward from May 20 would land on Fri May 29 (Thu 21, Fri 22, Mon 25, Tue 26, Wed 27, Thu 28, Fri 29). With the carrier's May 25 (Memorial Day, Mon) holiday in the list, that Monday is skipped — so the count rolls to Mon Jun 1 (Thu 21, Fri 22, Tue 26, Wed 27, Thu 28, Fri 29, Mon Jun 1). The holiday pushes the delivery date from Friday to the next business day after the weekend — three calendar days, but only one extra business day on the count.

The right tool is WORKDAY — the cousin of NETWORKDAYS — which takes a start date, a number of business days, and an optional holiday range, and returns the delivery date that many business days later (skipping weekends and holidays).

Compose with an IFS that picks the lead time per region:

=TEXT(WORKDAY(B2, IFS(C2 = "US", 3, C2 = "EU", 5, C2 = "APAC", 7), $F$2:$F$5), "yyyy-mm-dd")

The IFS returns the right business-day count; WORKDAY walks that many business days forward; TEXT formats the result as a yyyy-mm-dd string for the downstream system.

Your task:

1. In column D (Estimated Delivery), write a WORKDAY-based formula that returns the delivery date as a yyyy-mm-dd string.
2. The formula must drag-fill from D2 → D13.

Graded cells: D2 (2026-01-05 US +3bd → 2026-01-08), D4 (2026-01-15 APAC +7bd → 2026-01-27), D10 (2026-05-20 APAC +7bd, crosses Memorial Day holiday → 2026-06-01).