Formualizer Docs
ReferenceFunctionsDate & Time Functions

DAYS360

DAYS360: Returns the day count between two dates using a 30/360 convention.

Summary

Returns the day count between two dates using a 30/360 convention.

Remarks

  • method omitted or FALSE uses U.S. (NASD) rules; TRUE uses the European 30E/360 method.
  • Inputs are coerced to dates by truncating serials to integer days.
  • Serials are interpreted with the Excel 1900 date mapping, not a workbook-specific date system.

Examples

U.S. 30/360 method
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
30
European 30E/360 method
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
28

FAQ

Why does DAYS360 differ from actual day counts?

DAYS360 applies 30/360 financial conventions, so month-end dates are adjusted by rule instead of using calendar day totals.

Runtime metadata

Category

Date & Time

Signature

DAYS360(arg1: Number, arg2: Number, arg3…: Any)

Arity

min 2, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/datetime/date_parts.rs

DAYS

Returns the number of whole days between two date serial values.

EDATE

EDATE: Returns the serial date offset by a whole number of months from a start date.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does DAYS360 differ from actual day counts?Runtime metadata