How to Use the DAYS360 Function in WPS on Windows

Last updated:July 23, 2026

This how-to guide includes 3 topics for using DAYS360, covering formula field creation, parameter review, and example writing; 3 topics are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call DAYS360Free
22. Review the DAYS360 parameter formatFree
33. Write a DAYS360 usage exampleFree

How-to Guide

1. Create a formula field and call DAYS360

Entry: Add Field → Formula

  1. Open the multidimensional table you want to edit.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter a formula that includes DAYS360 in the formula editor.
  5. Click Confirm to save and check whether the result appears in the related record.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • Next action available: The field shows a calculated result and can still be edited.

Tips While Using

  • Common mistake: If you do not choose the formula field type first, you cannot enter a function formula.
  • Environment note: If table permissions are limited, you may not be able to add a field.

2. Review the DAYS360 parameter format

Entry: Formula Editor → Function Library → DAYS360

  1. Open the formula editor in an existing formula field.
  2. Open the function library and search for or select DAYS360.
  3. Review the parameter order and input format.
  4. Fill in the parameters with actual date fields or date values.

Success Criteria

  • Interface result: You can see the DAYS360 function name and parameter structure.
  • Next action available: You can continue editing and save the full formula.

Tips While Using

  • Common mistake: If the parameter order is wrong, the result may be incorrect or return an error.
  • Environment note: Date parameters should use values or fields that can participate in date calculations.

3. Write a DAYS360 usage example

Entry: Formula Editor

  1. Enter an example formula that includes DAYS360 in the formula field.
  2. Fill in the start date and end date based on your business needs.
  3. If more logic is needed, combine it with other functions.
  4. Save the formula and check whether the result updates automatically with record data.

Success Criteria

  • Interface result: The formula field displays a usable calculation result.
  • Next action available: After date data changes, the result refreshes accordingly.

Tips While Using

  • Common mistake: Using plain text directly as a date may cause the calculation to fail.
  • Environment note: For longer combined formulas, check parameters step by step.