DAYS360 in WPS on Windows FAQ

When using DAYS360, the most common issues fall into 3 areas: formula errors, parameter understanding, and unexpected results; this FAQ includes 3 common questions and a glossary.

FAQ

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

1. Check whether the formula starts with =.
2. Check whether the parentheses, commas, and number of arguments are correct.
3. Confirm that the start date and end date cells contain valid date values.
4. If needed, test again with =DAYS360(start_date,end_date,[method]).

What does the third argument in DAYS360 do?

1. The third argument, method, specifies the date-count method.
2. If you omit it, the function uses its default calculation method.
3. If your business scenario requires a different convention, enter the method value and compare the result.

Why is the DAYS360 result different from directly subtracting two dates?

1. DAYS360 uses a 360-day year rule rather than a natural-day difference.
2. Results can differ when dates fall at month end or across different months.
3. Use DAYS360 for fixed accounting-style conventions, and use other date calculations when you need natural-day differences.

Glossary