Practice free

DAYS360 function

DAYS360 returns the number of days between two dates on a 360-day year made of twelve 30-day months. It suits some accounting and bond calculations, but everyday work usually uses plain subtraction.

Example

Read it as a sentence: count the days between January 31, 2024 and March 31, 2024 on a 360-day year with 30-day months, which gives 60.

Practice this in the app

Syntax

DAYS360(start_date, end_date, [method])

Arguments in [square brackets] are optional.

start_date (required)
The earlier date.
end_date (required)
The later date.
method (optional)
FALSE or omitted for the US method; TRUE for the European method.

Returns: Days between dates on a 360-day year of twelve 30-day months.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=DAYS360(DATE(2026,1,31),DATE(2026,3,31)) 60 US method, 31st days
=DAYS360(DATE(2026,1,31),DATE(2026,3,31),TRUE) 60 European method
=DAYS360(DATE(2026,2,28),DATE(2026,3,31)) 30 US, last day of February
=DAYS360(DATE(2026,2,28),DATE(2026,3,31),TRUE) 32 EU, last day of February
=DAYS360(DATE(2026,3,31),DATE(2026,1,31)) -60 Reversed
=DAYS360("abc",1) #VALUE! Bad date
=DAYS360(DATE(2026,1,1),DATE(2026,2,1),"x") #VALUE! Method text

Watch out for

  • Results differ from real calendar day counts by design.
  • The US and European methods treat month-end dates differently.

Where it works

Excel
DAYS360 is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .