DATEINWORDS Function

The DATETOTEXT() function returns a date written out in full words (text format).

Format

DATEINWORDS(DATE;LANGUAGE)

where:

• DATE — a date or a formula that returns a date as the result.
• LANGUAGE — an empty string (defaults to the current user's language) or a two-letter language code such as de, en, uk, etc.

Examples

%%%DATETOTEXT("24-03-2025";"en")%%%

Result:

twenty-fourth march twenty twenty-five