DATE.FORMAT
The DATE.FORMAT() function returns the current date in the specified string format. If you do not specify a format, the function returns the date in the format based on the user's browser locale.
Syntax
DATE.FORMAT([format])Arguments
format(optional): The format in which to display the current date.
Return value
Returns the current date as a formatted string.
Examples
DATE.FORMAT()Returns the current date in the browser locale format, such as 11/6/24.
DATE.FORMAT("DD MM YY")Returns the current date in the specified format, such as 11 06 24.
Last updated
Was this helpful?