DAYS360 - Returning the Difference Between Two Dates

Last update：December 20, 2024

Overview

Syntax	DAYS360(Start_date,End_date,Method)	Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. You can use this function to help compute payments if your accounting system is based on twelve 30-day months.
Parameter 1	Start_date	The Start_date and End_date parameters are two dates between which you want to know the number of days.
Parameter 2	End_date
Parameter 3	Method	Represents the logical value that specifies whether to use the U.S. or European method in the calculation. Definition: If the method is set to FALSE or be empty, the U.S. (NASD) method is used. If the method is set to TRUE, the European method is used, where starting dates and ending dates that occur on the 31st day of a month become equal to the 30th day of the same month.

Notes

Direct-connected data is not supported.
The function supports three parameters. The third parameter can be the default value or of the text or numeric type. The first two parameters can be of the date or text types.
The true(TRUE) and false(FALSE) in the Method parameter are case-insensitive and marked in blue.

Example

Formula	Result	Note
DAYS360("1998/1/30","1998/2/1")	1

Previous

Next

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

滑鼠選中內容，快速回饋問題

滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。

不再提示

10s後關閉

Get
Help

*Problem Type

Incomprehensible Content Incorrect Content Incomplete Procedure Other Content Problems Doc Page Function Feedback

Cannot be empty

Problem Description

0/1000

Cannot be empty

Submitted successfully

Network busy