The date function creates a date of a specific value of the user’s choosing.

Syntax

DATE(x,y,z)

Parameters

x = Year as a 4-digit integer.

y = Month as an integer between 1 and 12.

z = Day as an integer between 1 and 31.

Type of Data Returned

The date function will return a date.

Examples

DATE(2019,8,22) will return 22^nd of August 2019.

Instead of using a date attribute on an item, using a specific date value to assess if items are “late” or “on-time” against the current date.

IF(TODAY()>DATE(2019,8,22), “late”, “on-time”)

Use the DATE() function to build a date out of NUMBERS E.g. DATE(2019, 12, 2) for '2 Dec 2019'

Note that unlike NUMBERs there are rules about the order of calculation for dates.

DATE1 - DATE2 = NUMBER OF DAYS (where Date1 is chronologically earlier than Date2)

DATE2 - DATE1 = -NUMBER OF DAYS (where Date1 is chronologically earlier than Date2)

DATE + DATE = INVALID

NUMBER + DATE = INVALID

DATE + NUMBER = DATE (Number assumed to be days). 

Multiply and Divide are not valid operators.

See also TODAY(), ADDDAYS(), ADDMONTHS() operators.