DAYS360 Function in Google Sheets

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

DAYS360 Function

The DAYS360 function calculates the number of days between two dates based on a 360-day year.

Syntax

DAYS360(start_date, end_date, [method])
  • start_date: The start date of the period.
  • end_date: The end date of the period.
  • method: Optional. A logical value that specifies the day count method (TRUE for US, FALSE for European).

Examples

  1. Basic Example

Calculate the number of days between August 14, 2024, and January 1, 2024:

=DAYS360(DATE(2024, 8, 14), DATE(2024, 1, 1))
  1. Using Method

Calculate using the US method:

=DAYS360(DATE(2024, 8, 14), DATE(2024, 1, 1), TRUE)

Notes

  • This function is useful for accounting and financial calculations that assume a 360-day year.
  • DAYS: Calculates the number of days between two dates based on the actual calendar year.