Function Problems

How to Calculate Project Due Dates with IFS and WORKDAY

Muhammad TalhaMuhammad Talha Nov 11, 2026 869 views

Question details

The user needs to calculate project due dates by adding a specific number of workdays based on an indicator value using the IFS and WORKDAY functions.

How to Calculate Project Due Dates with IFS and WORKDAY
Product
Spreadsheet
Device & OS
not provided
Scenario
Managing project timelines where tasks have variable durations depending on a specific condition or indicator.
Observed behavior
The user wants to dynamically output a due date that excludes weekends, shifting the deadline by 10 or 14 workdays based on an indicator of 0 or 1.
Before you start

Ensure your 'Assigned Date' column contains properly formatted date values and that your indicator column uses exact values (like 0 and 1) before applying the formula.

Solution 1Recommended

Combine IFS and WORKDAY Functions

Use a nested formula to evaluate the indicator value and calculate the corresponding workdays.

The WORKDAY function adds a specific number of working days to a date, automatically skipping weekends. By wrapping it inside an IFS function, you can apply different workday additions based on your project's specific criteria.

1
Select the target cell

Click on the cell in your table where you want the calculated due date to appear.

2
Enter the nested formula

Type the following formula into the formula bar: =IFS([@Indicator]=0,WORKDAY([@[Assigned Date]],10),[@Indicator]=1,WORKDAY([@[Assigned Date]],14))

3
Apply and format

Press Enter to apply the formula. If the result shows as a plain number, navigate to the Home tab and change the Number Format to 'Short Date'.

4
Fill the column

Drag the fill handle at the bottom-right corner of the cell down to apply this formula to the rest of your project table.

Combine IFS and WORKDAY Functions
Formula Syntax Check: Ensure that the IFS arguments are properly separated by commas and do not contain extra equals signs within the logical tests. If you are not using an official Table format, replace table references like [@Indicator] with standard cell references like B2.
Manage Projects Efficiently

Calculate Dates Easily with WPS Spreadsheet

WPS Spreadsheet fully supports advanced logical and date functions like IFS and WORKDAY. You can seamlessly manage project schedules, calculate deadlines, and track milestones for free.

  1. 1. Open your tracker: Launch WPS Spreadsheet and open your project management workbook.
  2. 2. Access the Function Wizard: Click on the 'Formulas' tab and select 'Insert Function' to easily find IFS or WORKDAY.
  3. 3. Input the arguments: Input your logical conditions and workday values into the intuitive function arguments dialog box.
  4. 4. Format as Date: Use the formatting dropdown on the 'Home' tab to ensure your formula results display properly as dates.
Fully compatible with Microsoft Excel formulas and date formatsBuilt-in function wizard to help you write complex IFS statementsFree, lightweight, and fast spreadsheet processingSeamlessly transition your existing project tracking workbooks
microsoft office alternative - wps office

Frequently Asked Questions

What happens if I want to exclude public holidays from my due date calculation?

You can add an optional third argument to the WORKDAY function that references a range of cells containing your holiday dates. For example, your WORKDAY section would look like: WORKDAY([@[Assigned Date]], 10, HolidayList).

Why does my formula return a #NAME? error?

This usually means the function name is misspelled or you are using an older spreadsheet version that does not support the IFS function. If IFS is unavailable, you can achieve the same result using nested IF functions: =IF([@Indicator]=0, WORKDAY(...), IF([@Indicator]=1, WORKDAY(...))).

Why is the formula result showing as a 5-digit number instead of a date?

Spreadsheets store dates as sequential serial numbers for calculation purposes. If you see a number like 44500, simply select the cell, go to the Home tab, and change the Number Format dropdown from 'General' to 'Short Date'.

Can I use standard cell references instead of table references?

Yes. If your data is not formatted as an official Data Table, you can replace table references like [@Indicator] with standard cell references like B2, and [@[Assigned Date]] with A2.