DATE

Definition: DATE is a function that returns the serial number of a date.

Syntax: =DATE(year, month, day)

Situation: This formula is suitable when you need to convert a date to its serial number, or when performing calculations on dates.

Example: If you have a date January 1, 2021, the serial number can be found using the formula =DATE(2021, 1, 1), which returns 44197.