Skip to Content

DAYS360

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

Syntax

DAYS360(start_date, end_date, [method])

Parameters

  • start_date: Required. The start date
  • end_date: Required. The end date
  • method: Optional. FALSE or omitted = U.S. (NASD) method; TRUE = European method

Example

=DAYS360("1/1/2024", "12/31/2024")
Returns: NumberSince: Excel 2003