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
| Argument | Required? | What it does |
|---|---|---|
| start_date | Yes | The first date. |
| end_date | Yes | The second date. |
| method | Optional | FALSE 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)
| A | B | C | |
|---|---|---|---|
| 1 | Start | End | 30/360 days |
| 2 | 1/31/2026 | 3/31/2026 | 60 |
| 3 | 1/1/2026 | 12/31/2026 | 360 |
| 4 | 3/15/2026 | 6/15/2026 | 90 |
=DAYS360(A2,B2) 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

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.