SheetFX
≡
<< Go back to all functions

DAYS360

The DAYS360 function in Google Sheets is a useful tool for calculating the difference between two dates based on a 360-day year. This function is commonly used in financial interest calculations. Learn how to effectively utilize this function with our comprehensive guide below.

Function Syntax and Parameters

Syntax: DAYS360(start_date, end_date, [method])

Parameters:

  • start_date: The start date to consider for the calculation.
  • end_date: The end date to consider for the calculation.
  • method: [Optional] Determines the method to be used while calculating the difference between the dates. If not specified, the method defaults to the U.S. method.

Step-by-Step Tutorial

  1. Calculating the difference between two dates using the U.S. method:

    • Example: =DAYS360("01/01/2021", "12/31/2021")
    • Result: 360

  2. Calculating the difference between two dates using the European method:

    • Example: =DAYS360("01/01/2021", "12/31/2021", TRUE)
    • Result: 359

Use Cases and Scenarios

  1. Financial Interest Calculations: Determine interest rates or payments based on a 360-day year.
  2. Loan Calculations: Calculate the duration of a loan using the 360-day year.
  3. Investment Analysis: Analyze investment returns over a specific period of time using the 360-day year.

Related Functions

  • DATEDIF: Calculate the difference between two dates using various units of time.
  • EOMONTH: Determine the last day of the month, a specified number of months before or after a given date.

Related Articles