DATE Function

Freebeginner 15 min5 tasks0/84 pts

DATE builds a real date from a year, month and day. Excel stores dates as serial numbers (days since 1900), so you can add and subtract them. DATE also rolls over sensibly: month 14 becomes February of the next year.

Syntax

DATE(year, month, day)

Example: =DATE(2024,3,15) is 15 March 2024. =D2+30 is 30 days later.

Common mistakes

Typing dates as text, so they cannot be calculated with.
Forgetting to format the cell as a Date, so you see a serial number.

SUMPRODUCT Function TODAY Function