DATESTRING

DATESTRING is a legacy compatibility function that formats a date serial number as a locale-specific text string. Because its output format depends on system locale and it is not available in all environments, TEXT with an explicit format code is preferred for portable date-to-text conversion.

Excel

=DATESTRING(DATE(2024,6,15))

Google Sheets

=DATESTRING(DATE(2024,6,15))

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1Provide a date serial number or a DATE() expression as the single argument.
2The function returns a text string formatted according to the system locale — e.g. '06/15/2024'.
3Consider using =TEXT(A2,"YYYY-MM-DD") instead for consistent, locale-independent output.

Need a version for your data?

Try: “Convert date serial numbers to text strings using the system date format”

TODAY / DATEDIF EOMONTH NETWORKDAYS

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

DATESTRING

Try it with your data

How it works

Related