How to Calculate Project Due Dates with IFS and WORKDAY
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.

- 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.
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.
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.
Click on the cell in your table where you want the calculated due date to appear.
Type the following formula into the formula bar: =IFS([@Indicator]=0,WORKDAY([@[Assigned Date]],10),[@Indicator]=1,WORKDAY([@[Assigned Date]],14))
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'.
Drag the fill handle at the bottom-right corner of the cell down to apply this formula to the rest of your project table.

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. Open your tracker: Launch WPS Spreadsheet and open your project management workbook.
- 2. Access the Function Wizard: Click on the 'Formulas' tab and select 'Insert Function' to easily find IFS or WORKDAY.
- 3. Input the arguments: Input your logical conditions and workday values into the intuitive function arguments dialog box.
- 4. Format as Date: Use the formatting dropdown on the 'Home' tab to ensure your formula results display properly as dates.

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.




