Function Problems

Calculate Priority-Based Due Dates Excluding Weekends in Excel

Partner Editor Oct 12, 2026 868 views

Question details

The user needs a formula to calculate task due dates based on priority levels (e.g., High, Medium, Low) while strictly excluding weekends from the day count.

Product: Excel and SharePoint
Device & OS: not provided
Scenario: Setting up a project management tracking spreadsheet where turnaround times depend on task priority, requiring calculations in business days rather than calendar days.
Observed behavior: Need a dynamic formula to calculate the due date without counting Saturdays and Sundays, ensuring the exact result accounts for whether the creation date counts as the first day.

Before you start

Ensure your task table is organized with dedicated columns for the 'Created Date' and the 'Priority' level. Verify that your priority labels exactly match the text you plan to use in your formula conditions.

Solution 1Recommended

Use the WORKDAY Function Combined with Nested IF Statements

This is the cleanest and most reliable method to calculate future dates while automatically skipping weekends dynamically based on priority criteria.

The WORKDAY function is designed to add a specified number of business days to a starting date, naturally excluding Saturdays and Sundays. By embedding a nested IF statement into the days argument, you can assign different duration values depending on the text in your priority column.

Select the Due Date cell

Click on the first cell in your Due Date column where you want the calculated date to appear.

Input the WORKDAY formula

Type the formula =WORKDAY(A2, IF(B2="High", 3, IF(B2="Medium", 5, 7))) into the formula bar. In this example, A2 is the Created Date and B2 is the Priority. It assigns 3 days for High priority, 5 for Medium, and 7 for anything else.

Apply to the entire column

Press Enter to execute the calculation. Select the cell again, grab the fill handle at the bottom right corner, and drag it down to apply the formula to all your tasks.

Use the WORKDAY Function Combined with Nested IF Statements

Start Date Counting: The WORKDAY function starts counting from the day after the start date. If you need the creation date to count as 'Day 1', you should subtract 1 from the days inside the IF function (e.g., use 2 instead of 3 for High priority).

Solution 2

Construct a Custom Formula Using IF and WEEKDAY Functions

Useful for specific scenarios or legacy systems where WORKDAY is not applicable, allowing manual adjustments based on the day of the week.

Efficient Spreadsheet Management

Calculate Task Due Dates Seamlessly with WPS Spreadsheet

WPS Spreadsheet offers full native support for advanced date functions like WORKDAY, WORKDAY.INTL, and nested IF logic. You can build dynamic project schedules, task trackers, and priority-based timetables effortlessly.

1. Open your data in WPS Spreadsheet: Launch WPS Office, open Spreadsheet, and load your task management workbook.
2. Prepare your columns: Ensure you have clear columns for 'Start Date' and 'Priority' (e.g., High, Medium, Low).
3. Enter the formula: In your Due Date column, enter =WORKDAY(A2, IF(B2="High", 3, IF(B2="Medium", 5, 7))) and adjust the cell references as needed.
4. Format and apply: Press Enter, format the cell as a Date if required, and drag down to apply the calculation to all rows.

100% compatibility with Microsoft Excel formulas and date functionsBuilt-in date formatting tools to easily display your resultsLightweight application that runs smoothly across desktop and mobile platformsFree to use with a highly intuitive, tab-based user interface

microsoft office alternative - wps office

Frequently Asked Questions

Does the WORKDAY function exclude public holidays as well?

By default, WORKDAY only excludes Saturdays and Sundays. To exclude public holidays, you can add a third argument to the formula referring to a range of cells containing holiday dates. For example: =WORKDAY(start_date, days, E2:E10).

How can I adjust the formula if my priority names change?

You simply need to update the text strings inside the IF statements of the formula. For example, change "High" to "Urgent". Ensure that the text you type in the formula exactly matches the text found in your priority column, as it is case-insensitive but sensitive to exact spelling and spacing.

What if I need to include Saturdays but exclude Sundays?

Instead of the standard WORKDAY function, use the WORKDAY.INTL function. It includes an extra argument that allows you to specify exactly which days of the week should be treated as weekends using a special numeric code (e.g., use the code 11 for Sunday-only weekends).

Why does my date formula return a 5-digit number instead of a date?

Excel and WPS Spreadsheet store dates as sequential serial numbers for calculation purposes. To fix the display, select the cells containing the 5-digit numbers, right-click, choose 'Format Cells', and apply your preferred 'Date' format.

Excel & Data Problems