XL.FormatDate function

XL.FormatDate function – Text function type – converts date and time value to its equivalent string representation using the specified format and culture-specific format information.

Syntax

=XL.FormatDate(format, date, locale)

ArgumentDescription
format
[required]
A standard or custom date and time format string.
date
[required]
A date and time value to be formatted.
locale
[required]
Two or five symbols of country code, e.g. en-US, en-GB, CN, RU, FR, etc.

Any questions or suggestions?
How can we help?