How to Use the DAYS360 Function in WPS on Windows

This how-to guide includes 4 task topics for using DAYS360 in WPS Spreadsheets on Windows; choose a topic from the index and follow the steps to enter, check, and recalculate the formula.

How-to Index

How-to Guide

1. Enter a basic DAYS360 formula

Entry point: Formula tab → formula bar

1. Open WPS Spreadsheets and select the cell where you want the result to appear.
2. Type = to begin the formula.
3. Type DAYS360(.
4. Get ready to enter the start date and end date arguments.

Success Criteria

• On-screen result: The selected cell enters formula editing mode.
• Next action available: You can see the function name and continue entering arguments.

Tips While Using

• Common mistake: If you do not type = first, the content may be treated as plain text.

2. Fill in function arguments with prompts

Entry point: Formula bar → function prompt

1. After DAYS360(, enter the start date argument.
2. Type a comma and then enter the end date argument.
3. Add the optional method argument if needed.
4. Type the closing parenthesis and press Enter.

Success Criteria

• On-screen result: A numeric result appears in the current cell.
• Next action available: When you select the cell again, the full formula is visible in the formula bar.

Tips While Using

• Common mistake: Missing a closing parenthesis or separator can cause a formula error.
• Environment note: Date arguments should be valid dates or references that can participate in date calculations.

3. Reference dates across worksheets

Entry point: Formula bar → worksheet cell references

1. Start by typing DAYS360( in the formula.
2. Switch to the worksheet that contains the start date and select the target cell.
3. Enter the separator, then select the cell that contains the end date.
4. Complete the formula and press Enter.

Success Criteria

• On-screen result: The formula shows worksheet references.
• Next action available: If the referenced dates change, the result can update with them.

Tips While Using

• Common mistake: Referencing text instead of a date cell can produce an unexpected result.

4. Check results and trigger recalculation

Entry point: Result cell → formula bar / keyboard recalculation

1. Check whether the result cell returns a numeric value.
2. Confirm that the start date and end date references are correct.
3. If the source data changed but the result did not, press F9 to recalculate.
4. If needed, edit the formula again and confirm the argument order.

Success Criteria

• On-screen result: The result stays aligned with the current date data.
• Next action available: You can use the result in other formulas.

Tips While Using

• Common mistake: If the start date is later than the end date, the result may be negative.