Excel functions / Date & Time
DAYS360 function
Days between two dates in a year of twelve 30-day months, as some accounts count them.
Syntax
=DAYS360(start_date, end_date, [method])
Arguments
start_date: The first date.end_date: The last date.method(optional): FALSE (default): the US method. TRUE: the European method.
When to use it
DAYS360 counts the days between two dates as if every month had 30 days and the year 360. Some accounting and interest calculations are done this way, so that every month is worth the same.
Examples
A quarter on a 360-day year
A B C D 1 From To 2 2026-01-31 2026-04-30 90 In D2:
=DAYS360(A2, B2)→ 90The real number of days is 89.
February counts as 30 days
A B C D 1 From To 2 2026-02-01 2026-03-01 30 In D2:
=DAYS360(A2, B2)→ 30
Common mistakes
- Using it for real day counts. DAYS360 is a convention, not a count. For the actual number of days, subtract the dates or use DAYS.
DAYS360 in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: ROK360
- Danish: DAGE360
- Dutch: DAGEN360
- Finnish: PÄIVÄT360
- French: JOURS360
- German: TAGE360
- Hungarian: NAP360
- Italian: GIORNO360
- Norwegian: DAGER360
- Polish: DNI.360
- Portuguese (Brazil): DIAS360
- Portuguese (Portugal): DIAS360
- Russian: ДНЕЙ360
- Spanish: DIAS360
- Swedish: DAGAR360
- Turkish: GÜN360