DATE

The DATE function converts a date value into the specified format. You can provide the input either as a date string or as separate year, month, and day values. If you do not specify a format, the function returns the date in the browser locale format.

Syntax

1. Returns the date in the specified format.

DATE(date, format)

2. Returns the date in the browser locale format.

DATE(year, month, date)

Arguments

• date: The input date as a string, reference, or measure that contains a date value.
• format (optional): The format in which to display the date.

or

• year: The year value.
• month: The month value.
• date: The day value.

Return value

Returns the formatted date value.

Examples

DATE("05/30/2026")

Returns 5/30/2026.

DATE(2026, 05, 22)

Returns 5/22/2026.

Excel equivalent

DATE