Google Sheets Function

DAYS360

Calculates the number of days between two dates based on a 360-day year.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

DAYS360(start_date, end_date, [method])

The DAYS360 function is commonly used in accounting and financial calculations where a 360-day year is standard. It treats every month as having 30 days, which helps simplify interest calculations for financial models.

Arguments

start_daterequiredThe starting date of the period.
end_daterequiredThe ending date of the period.
methodoptionalA logical value that specifies whether to use the U.S. (NASD) or European method.

Examples

=DAYS360("2023-01-01", "2023-02-01")

Result: 30

Calculates the difference between January 1st and February 1st, returning 30 days.

FAQ

Why does DAYS360 return 30 days for a month?

It uses a 360-day year convention (12 months of 30 days each) which is a standard in financial accounting.

Related functions

DAYS NETWORKDAYS YEARFRAC