Day Count
Counts calendar days between two dates, inclusive or exclusive of endpoints.
Day count (inclusive)
221
Inclusive: both endpoints are counted (1 Jan → 2 Jan = 2 days). For a pure difference between dates use “Date difference”.
Advertisement
Formula
inclusive count = |date₂ − date₁| + 1 (both endpoints); optional exclusive without +1
Example: 2026-01-01 to 2026-01-02 inclusive = 2 days; exclusive = 1 day
Methodology
Calendar days between dates - default inclusive of endpoints; can switch to exclusive.
Example
1 Jan to 2 Jan = 2 days (inclusive) or 1 day (exclusive).