DAYS360 Function

Counts the days between two dates using a 360-day accounting year.

Category

Date & Time

Available in

All versions, Microsoft 365

Returns

A whole number of days

Want to practice DAYS360 in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

Some accounting systems treat every month as 30 days and every year as 360. DAYS360 counts days that way, so interest and accruals match those systems.

The US (NASD) method is the default; set method to TRUE for the European method.

Syntax

=DAYS360(start_date, end_date, [method])

Arguments

ArgumentRequired?What it does
start_dateYesThe first date.
end_dateYesThe second date.
methodOptionalFALSE or omitted: US method. TRUE: European method (any 31st becomes the 30th).

Examples

Example 1 — Accrual periods on a 30/360 basis

Each month counts as 30 days, whatever its real length.

C2fx=DAYS360(A2,B2)
ABC
1StartEnd30/360 days
21/31/20263/31/202660
31/1/202612/31/2026360
43/15/20266/15/202690
=DAYS360(A2,B2) Explain

Example 2 — European method

Pass TRUE as the third argument.

=DAYS360(A2, B2, TRUE) Explain

Common mistakes

  • Results don't match a calendar count. That's the point — DAYS360 is for 30/360 accounting. Use DAYS for real calendar days.

Notes

  • Related functions: YEARFRAC (basis 0 and 4 use the same 30/360 rules), DAYS.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.