DATE.SET

The DATE.SET() function can be used to change the format of a date. Refer to Microsoft's date format codes to view all the supported format models. The input date should be in MM/DD/YYYY format.

Syntax

date.set(date, format_model)

Arguments

date - The date which is passed as input to the function.

format_model - The new date format to be applied to the input date

Return value

Date

Example

DATE.SET('03/01/2026', 'YYYYMMDD')

Returns 20260301.

DATE.SET function