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.
DATE.FORMAT([format])
format (optional): The format in which to display the current date.Returns the current date as a formatted string.
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.