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

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

  1. A quarter on a 360-day year

    ABCD
    1FromTo
    22026-01-312026-04-3090

    In D2: =DAYS360(A2, B2) → 90

    The real number of days is 89.

    Try this example

  2. February counts as 30 days

    ABCD
    1FromTo
    22026-02-012026-03-0130

    In D2: =DAYS360(A2, B2) → 30

    Try this example

Common mistakes

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.

Translate a whole formula

Try DAYS360 in the playground

Related functions