How to Use the WEEKDAY Function in WPS on Windows

Last updated:July 23, 2026

Use WEEKDAY in 3 how-to topics: create a formula field and call WEEKDAY, check the parameter format, and build common examples; 3 topics are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership
11. Create a formula field and use WEEKDAYFree
22. Check the WEEKDAY parameter formatFree
33. Build common WEEKDAY examplesFree

How-to Guide

1. Create a formula field and use WEEKDAY

Entry point: Add Field → Formula

  1. Open the multidimensional table that you want to edit.
  2. Click Add Field on the toolbar.
  3. Select Formula as the field type.
  4. Enter a formula that includes WEEKDAY in the formula editor.
  5. Click Confirm to save and review the calculated result in the record list.

Success Criteria

  • Interface result: A new formula field appears and shows calculated values.
  • Next action: You can continue editing the formula or adjust other fields.

Tips While Using

  • Common mistake: If the parameter is not a valid date, the result may not match your expectation.
  • Environment note: You need permission to edit fields in the current multidimensional table.

2. Check the WEEKDAY parameter format

Entry point: Formula Editor → Function Library

  1. Open the formula editor in your multidimensional table.
  2. Open the function library and find WEEKDAY.
  3. Review the parameter format shown for the function.
  4. Enter parameters based on the date data in your current field.

Success Criteria

  • Interface result: You can see the WEEKDAY function name and parameter structure in the editor.
  • Next action: You can apply the format directly in the current formula.

Tips While Using

  • Common mistake: Entering plain text instead of a valid date value can cause incorrect results.

3. Build common WEEKDAY examples

Entry point: Formula Editor

  1. Open an existing formula field or create a new one.
  2. Enter a formula that includes WEEKDAY, such as a formula that returns a weekday number from a date field.
  3. If needed, add conditional logic to separate weekdays from weekends.
  4. Save the formula and check the returned values for each record.

Success Criteria

  • Interface result: Each record shows the weekday number for its date.
  • Next action: You can continue filtering, grouping, or summarizing based on the result.

Tips While Using

  • Common mistake: Saving the formula without checking the weekday numbering rule can affect later classification.