Date & Time
Calculate due date by category or SLA priority (business or calendar days)
Look up turnaround days by ticket priority or vendor payment tier with XLOOKUP and add business days via WORKDAY.
Data-driven SLA turnaround tables beat hardcoded IFs
Embedding IF(B2="Critical", 1, IF(B2="High", 3, 10)) inside formulas scatters SLA rules across hundreds of rows. Storing Priority -> TurnaroundDays in a small lookup table (D2:E4) lets managers adjust SLA targets in one place.
Passing XLOOKUP(Priority, TierCol, DaysCol) as the second argument of WORKDAY(OpenDate, Days, [Holidays]) advances strictly by Monday–Friday business days.
| OpenDate (A) | Priority (B) | SLA Tier (D) | BizDays (E) | Due Date |
|---|---|---|---|---|
| 2026-05-08 (Fri) | High | Critical | 1 | 2026-05-13 (Wed) |
| High | 3 | |||
| Normal | 10 |
Business-day SLA due date formula
Opened Friday May 8 with a 3-business-day High SLA skips Saturday/Sunday and lands on Wednesday May 13.
=TEXT(WORKDAY(A2, XLOOKUP(B2, D2:D4, E2:E4, 5)), "yyyy-mm-dd")Calendar-day turnaround variant
Adding lookup days directly gives calendar-day turnaround. A real Net-15/30/60 invoice schedule needs a separate terms table with those values; the sample table contains 1/3/10-day priorities.
=TEXT(A2 + XLOOKUP(B2, D2:D4, E2:E4, 30), "yyyy-mm-dd")Inputs and interpretation
The unknown-priority fallback of five business days is an explicit example policy; flag unknown priorities for review if silently assigning a deadline is inappropriate. Use unique tier labels and integer nonnegative day counts. No holidays are excluded unless provided. WORKDAY returns a date rather than preserving the opening time, and TEXT produces a display string; omit TEXT for further date arithmetic.
Try the example
Use the original values or change them to test your understanding.