Calculate Repair Deadlines in Excel with IF and WORKDAY
Question details
Calculate repair deadlines based on priority while excluding weekends and listed holidays.

- 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.
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.
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.
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.
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",""))
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.

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. Open your worksheet: Open WPS Spreadsheets and select Open to load your repair workbook.
- 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. Enter the formula: Select M3 and enter =IF(L3=2,WORKDAY(K3,$S$16,$T$3:$T$12),IF(L3=3,"Next PM",""))
- 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.

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.




