Skip to content
Google Sheets

DAYS360 function in Google Sheets

Returns the difference between two days based on the 360 day year used in some financial interest calculations.

=DAYS360(start_date, end_date, [method])

DAYS360 syntax and parameters

Three arguments, two required.

  • start_dateanyRequired

    The start date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type, or a number.

  • end_dateanyRequired

    The end date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type, or a number.

  • methodnumberOptional

    [ OPTIONAL - 0 by default ] - An indicator of what day count method to use. 0 indicates the US method - Under the US method, if start_date is the last day of a month, the day of month of start_date is changed to 30 for the purposes of the calculation. Furthermore, if end_date is the 31st day of a month and the day of the month of start_date is earlier than the 30th, end_date is changed to the first day of the month following end_date. Otherwise, the day of month of end_date is changed to 30. Any other value indicates the European method - Under the European method, any start_date or end_date that falls on the 31st of a month has its day of month changed to 30.

DAYS360 examples

Formulas you'll actually reuse.

  1. Days on a 30/360 bond-market calendar (US method) — every month counts 30:

    =DAYS360(DATE(2026, 2, 28), DATE(2026, 3, 31))

    Result33

  2. The European variant caps the 31st at 30 on both ends:

    =DAYS360(DATE(2026, 2, 28), DATE(2026, 3, 31), TRUE)

    Result32

DAYS360 in Excel

Same name — your formula ports as-is.

Try DAYS360 in the playground

Edit the example — nothing to install.

Preloaded with the DAYS360 formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.