WORKDAY in WPS on Windows FAQ

Common WORKDAY questions usually involve argument formats, unexpected results, and batch filling; this FAQ includes 3 common questions and a glossary.

FAQ

Why does WORKDAY return a #VALUE! error?

1. Check whether start_date is a valid date instead of plain text.
2. Check whether the days argument contains spaces, text, or invalid characters.
3. If you referenced a holiday range, make sure the values in that range are also valid dates.
4. Confirm that the arguments are separated with commas.

Why is the WORKDAY result different from what I expected?

1. Check whether the start date is correct.
2. Confirm whether the sign of days matches your goal: positive values move forward and negative values move backward.
3. Check whether the holiday range in holidays is missing or incomplete.
4. Compare your requirement with the weekend rule you need and decide whether another workday-related function is more suitable.

How to use the WORKDAY function in WPS on Windows for multiple cells?

1. Enter the correct WORKDAY formula in the first cell.
2. Move the pointer to the fill handle at the lower-right corner of the cell.
3. Drag down or across to copy the formula to the target range.
4. If you need to lock the start date or holiday range, use the $ symbol for absolute references.

Glossary