DAYS360 in WPS on Windows FAQ

This FAQ covers 4 common questions about DAYS360 in WPS on Windows, including formula errors, argument prompts, result checks, and usage differences from direct date subtraction.

FAQ

What should I do if the DAYS360 function shows an error?

1. Check whether the formula starts with =.
2. Check whether the parentheses, commas, and argument count are complete.
3. Make sure the referenced cells contain valid dates instead of plain text.
4. Press Enter again after correcting the formula.

How do I view argument prompts for the DAYS360 function?

1. Select the target cell and type =DAYS360(.
2. Look for the function prompt near the formula editing area.
3. Enter the start date, end date, and optional argument in order.

Why is my DAYS360 result not correct?

1. Check whether the start date and end date were entered in reverse order.
2. Make sure the date cells can be used in date calculations.
3. If you used the method argument, confirm that the selected calculation rule matches your needs.
4. Press F9 to recalculate and review the result again.

What is the difference between DAYS360 and subtracting dates directly?

1. Direct date subtraction usually follows actual calendar days.
2. DAYS360 follows a 360-day year and 30-day month convention.
3. For finance or fixed-rule reporting, DAYS360 can help keep results consistent.

Glossary