Date Difference
Calculates days, weeks, and months between two calendar dates.
Day difference (exclusive)
220
Weeks
31,43
Exclusive: whole days between dates (1 Jan → 2 Jan = 1 day). For inclusive day count use “Number of days”.
Advertisement
Formula
day difference (exclusive) = |date₂ − date₁| whole days; 1 Jan → 2 Jan = 1
Example: 2026-01-01 to 2026-08-09 = 220 days (exclusive)
Methodology
Exclusive whole calendar-day difference between two dates (1 Jan → 2 Jan = 1). For inclusive count use Day Count.
Example
1 Jan 2026 to 31 Mar 2026 = 89 days (exclusive).