Function Problems

Calculate Repair Deadlines in Excel with IF and WORKDAY

Jason MillerJason Miller Nov 14, 2026 868 views

Question details

Calculate repair deadlines based on priority while excluding weekends and listed holidays.

Calculate Repair Deadlines in Excel with IF and WORKDAY
Product
Microsoft Excel
Device & OS
not provided
Scenario
A repair worksheet contains an acknowledgment date, a priority, a business-day interval, and a list of holidays.
Observed behavior
The desired result is a business-day deadline for priority 2, “Next PM” for priority 3, and a blank for other priorities.
Before you start

Enter valid Excel dates in K3 and T3:T12, a numeric priority in L3, and the business-day interval in S16. WORKDAY treats Saturday and Sunday as weekends.

Solution 1Recommended

Use IF and WORKDAY to calculate the repair deadline

Use this formula when priority 2 has a business-day deadline and priority 3 should display a text instruction.

1
Enter the source data

In the worksheet, enter the acknowledgment date in K3, the priority in L3, the business-day interval in S16, and holiday dates in T3:T12.

2
Add the formula

Select the deadline cell, such as M3, and enter =IF(L3=2,WORKDAY(K3,$S$16,$T$3:$T$12),IF(L3=3,"Next PM",""))

3
Format and copy the result

Select the deadline cell and choose Home > Number Format > Short Date if a date appears as a number. Drag the fill handle down to apply the formula to other repair rows.

Use IF and WORKDAY to calculate the repair deadline
Adjust priority outcomes: Priority 3 returns the text “Next PM,” not a calculated date. Other priorities return a blank; change the IF outcomes to match your workflow.
Calculate deadlines in WPS Spreadsheets

Calculate repair deadlines with WPS Spreadsheets

Use IF and WORKDAY in WPS Spreadsheets to calculate priority-based repair deadlines while excluding weekends and your listed holidays.

  1. 1. Open your worksheet: Open WPS Spreadsheets and select Open to load your repair workbook.
  2. 2. Enter the deadline inputs: Enter the acknowledgment date in K3, priority in L3, business-day interval in S16, and holiday dates in T3:T12.
  3. 3. Enter the formula: Select M3 and enter =IF(L3=2,WORKDAY(K3,$S$16,$T$3:$T$12),IF(L3=3,"Next PM",""))
  4. 4. Format and fill: Use the Home tab's number format control to format M3 as a date, then drag its fill handle down for additional repair rows.
Calculate business-day repair deadlines with IF and WORKDAYOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceGet started with WPS Office for free
QA img-9

Frequently Asked Questions

How does WORKDAY exclude holidays?

Add valid dates to T3:T12 and include $T$3:$T$12 as the third argument in WORKDAY. Dates in that range are excluded along with Saturdays and Sundays.

Why does my deadline appear as a number?

Excel stores dates as serial numbers. Select the result cell and choose Home > Number Format > Short Date.

What happens when the priority is not 2 or 3?

The final empty string in the IF formula returns a blank. Replace it with another value or formula if other priorities need an outcome.

Can I use different weekend days?

In Excel, use WORKDAY.INTL instead of WORKDAY and specify a weekend code or a seven-character weekend string. Keep the holiday range as the fourth argument.