How to Use the DATEDIF Function in WPS on Windows

Last updated:July 23, 2026

Use the How-to Index to choose from 3 tasks; all 3 are available without membership and 0 are membership-related.

How-to Guide

How-to Index

No.TaskAccess
11. Create a formula field and use DATEDIFFree
22. Review and fill in the parameter formatFree
33. Combine DATEDIF with other formulasFree

Step-by-Step Guide

1. Create a formula field and use DATEDIF

Entry path: Add Field > Formula

  1. Open the multidimensional table you want to edit.
  2. Select Add Field.
  3. Choose Formula as the field type.
  4. Enter a formula that includes DATEDIF.
  5. Save the field and check the returned result.

What success looks like

  • Interface result: A new formula field appears in the table and shows a calculated value.
  • Next action: You can continue editing the formula or adjust referenced fields.

Notes

  • Common issue: If a referenced field is not a valid date field, the result may not calculate as expected.
  • Environment note: You need an editable multidimensional table.

2. Review and fill in the parameter format

Entry path: Formula Editor > Function Library > DATEDIF

  1. Open the formula editor in your multidimensional table.
  2. Find DATEDIF in the function library.
  3. Enter parameters in the format DATEDIF(start date, end date, unit).
  4. Check that the start date and end date references are correct.
  5. Enter the unit you want to return, such as years, months, or days.

What success looks like

  • Interface result: The formula editor shows a complete DATEDIF structure.
  • Next action: After saving, the field can return a date difference value.

Notes

  • Common issue: If the parameter order is wrong, the result may be incorrect or fail.
  • Environment note: Date fields should contain valid date values.

3. Combine DATEDIF with other formulas

Entry path: Formula Editor

  1. Open an existing formula field or create a new one.
  2. Enter DATEDIF as the base date-difference calculation.
  3. Use the DATEDIF result as an input for another function when needed.
  4. Check brackets, separators, and field references in the nested formula.
  5. Save the formula and confirm that the result updates with the data.

What success looks like

  • Interface result: The formula field returns the combined calculation result.
  • Next action: When the source date fields change, the result updates as well.

Notes

  • Common issue: Missing brackets in nested formulas can prevent the formula from being saved.
  • Environment note: It helps to verify that DATEDIF works correctly on its own before combining it.