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.
A
B
C
D
1
60
2
3
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.
| Formula | Excel shows | Case |
|---|---|---|
=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 .