Syntax
DAYS360(start_date, end_date, [method])
| Parameter | Description |
|---|---|
| start_date | Parameter of the DAYS360 function. |
| end_date | Parameter of the DAYS360 function. |
| [method] | (Optional.) Parameter of the DAYS360 function. |
Examples
US/NASD method
Formula
=DAYS360("2026-01-30", "2026-02-28")
Returns 28 — using the US/NASD method (default), which adjusts month-end dates according to specific rules.
European method
Formula
=DAYS360("2026-01-30", "2026-02-28", TRUE)
Returns 28 — using the European method where any month-end date is treated as the 30th of that month.
Financial interest calculation
Formula
=B2 * (C2/360) * DAYS360(D2, E2)
Calculates simple interest: principal * (rate/360) * days. The 360-day convention simplifies interest computations for financial instruments.
Common Errors
#VALUE!
Occurs when either date argument is not a valid date or the method argument is not a boolean.
Tips
US vs European method
FALSE or omitted = US/NASD method (adjusts Feb and 31st-day dates). TRUE = European method (treats all month-ends as 30th). Know which your industry requires.
Financial standard
Many bond markets, loan calculations, and accounting systems use 30/360 day counting. DAYS360 implements this convention directly.
Not for general date math
For regular day counting, use DAYS or simple subtraction. DAYS360 is specifically for financial calculations that assume 30-day months.
Try DAYS360 in Viztab
Import your data and use DAYS360 with 370+ other formulas. No signup required.
Open Viztab