Count days between dates without time-zone confusion
Date only mode compares calendar dates and ignores hours. Switch to Date & time to compare UTC timestamps, see elapsed duration and count complete 24-hour periods. The two modes answer different questions when times cross midnight.
Formula and calculation method
Calendar difference = end date minus start date, using midnight UTC for each date. Timestamp duration = end timestamp minus start timestamp. Complete 24-hour days truncate the signed duration toward zero.
Worked example
15 November at 23:00 to 16 November at 01:00 spans one calendar day but only two elapsed hours, with zero complete 24-hour days.
Are local daylight-saving changes included?
No. Date-only mode compares dates independently of local time zones. The timestamp mode explicitly uses UTC rather than local daylight-saving rules.