ReferenceFunctionsDate & Time Functions
DAYS
Returns the number of whole days between two date serial values.
Summary
Returns the number of whole days between two date serial values.
Remarks
- Result is
end_date - start_date; negative results are allowed. - Fractional serial inputs are truncated to their date portion.
- Serials are interpreted with the Excel 1900 mapping (including the 1900 leap-year bug behavior).
- This function currently does not switch interpretation based on workbook
1900/1904mode.
Examples
Positive day difference
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
43
Negative day difference
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
-43
Related functions
FAQ
Does DAYS count partial-day time fractions?
No. DAYS truncates both serial inputs to whole dates before subtracting end_date - start_date.
Runtime metadata
Category
Date & Time
Signature
DAYS(arg1: Number, arg2: Number)Arity
min 2, max 2
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
Caps
PURE
Source