DAYS Function

Freebeginner 15 min4 tasks0/66 pts

DAYS returns the number of days between two dates. Mind the order: DAYS(end_date, start_date). Plain subtraction gives the same answer, but DAYS makes the intent clear.

Syntax

DAYS(end_date, start_date)

Example: =DAYS(C2,B2) is shipped date minus ordered date.

Common mistakes

Reversing the arguments, which gives a negative number.
Using DAYS on text that only looks like a date.

DATEDIF Function DATE Functions Skill Summary