Navigation:  Formulas and functions > Functions from A to Z > DATE (create a date value)

Syntax:

DATE(Year, Month, Day)

Description:

This returns a date created from the specified Year, Month and Day.

Example:

DATE(2018, 9, 25) returns 43368

However, Calculate automatically formats this date value in the number format "Date/Time", thus the cell reads: 09/25/2018.

See also:

DATEVALUE, TIME, TIMEVALUE