How to Use

Use DAYS360 through 3 how-to topics, including inserting it from the function dialog, typing the formula directly, and checking syntax details; choose a topic from the index and follow the entry path and steps.

How-to Index

How-to Guide

1. Insert DAYS360 from the Insert Function dialog

Entry path: Formula tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
3. Search for DAYS360 in the Insert Function dialog.
4. Select the function and click OK.
5. Enter each argument in the Function Arguments dialog.
6. Click OK to finish inserting the function.

Success Criteria

• Interface result: The target cell contains a DAYS360 formula.
• Next action available: You can continue editing the arguments or fill the formula to other cells.

Tips While Using

• Make sure the date arguments are valid date values.
• Use the correct argument separator required by your spreadsheet locale.

2. Type the DAYS360 formula directly in a cell

Entry path: Cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =DAYS360(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If you want to review the function prompt, type =DAYS360( and check the syntax hint shown in the editor.

Success Criteria

• Interface result: The cell shows a calculated result or the full formula.
• Next action available: You can copy the formula to other cells for more calculations.

Tips While Using

• If the result looks incorrect, check whether the start date and end date references are correct.
• When copying the formula, review relative and absolute references as needed.

3. Check DAYS360 syntax and argument details

Entry path: Formula tab → Insert Function

1. Click Insert Function on the Formula tab.
2. Enter DAYS360 in the search box.
3. Select the function and review the syntax: DAYS360(start_date, end_date, [method]).
4. Open the help link in the dialog if you need more details.

Success Criteria

• Interface result: The function name, syntax, and argument area are visible.
• Next action available: You can fill in the arguments and complete the insertion.

Tips While Using

• method is optional, so confirm which date-counting rule you need before entering it.
• Opening online help requires a working internet connection.