Google Sheets DAYS360 Function: Syntax, Examples & Tips

start_date:
The starting date of the period you want to evaluate. This can be a date value, a cell reference containing a date, or a formula that returns a date.

end_date:
The ending date of the period you want to evaluate. This can also be a date value, a cell reference containing a date, or a formula that returns a date.

method:
An optional parameter that specifies the method to use for calculating the days. If TRUE or omitted, the function uses the US method (360 days). If FALSE, it uses the European method (actual days).

What is the DAYS360 Function?

The DAYS360 function in Google Sheets is a useful tool for calculating the number of days between two dates based on a 360-day year. This function is particularly helpful in financial calculations, where a 360-day year is often used for interest calculations and other financial metrics. The DAYS360 function assumes that each month has 30 days, which simplifies the calculations.

In simpler terms, DAYS360 allows you to find the difference in days between two dates using a standardized method that is commonly used in finance.

A Practical Example

Imagine you are managing a loan portfolio and need to calculate the interest for a loan based on a 360-day year:

Loan Details Table:

You want to find out how many days each loan spans according to the 360-day year calculation.

DAYS360 Formula

To achieve this, you would use the DAYS360 function as follows:

=DAYS360(B2, C2)

In this formula:

• B2 is the cell containing the StartDate of the loan.
• C2 is the cell containing the EndDate of the loan.

Result of the Formula

When you apply the DAYS360 formula to the Loan Details Table, the output would look like this:

In this case, the DAYS360 function calculates that Loan 1 spans 59 days and Loan 2 spans 90 days according to the 360-day year method.

Why Use DAYS360?

DAYS360 is beneficial because it provides a standardized way to calculate the number of days between two dates for financial purposes. This function simplifies interest calculations and helps ensure consistency across financial reporting. Additionally, it allows for easier comparisons between different loans or financial products.

Key Takeaways:

• DAYS360: A function that calculates the number of days between two dates based on a 360-day year.
• Financial Applications: Commonly used in interest calculations and other financial metrics.
• Standardization: Provides a consistent method for date calculations, making it easier to compare financial data.
• Common Use Cases: Ideal for loan management, interest calculations, and any scenario where a 360-day year is applicable.

DAYS360 is an essential function for anyone working with financial data in Google Sheets, providing a powerful way to enhance financial analysis and reporting capabilities.

Happy spreadsheeting!