Convert date to text in Excel and Google Sheets

=TEXT(A2,"dd/mm/yyyy")

A2 = date cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Convert date to text in Excel

How to convert date to text in Excel?
Convert date to text in Excel

CONVERT DATE TO TEXT — EXCEL FORMULA AND EXAMPLE

=TEXT(A2,"dd/mm/yyyy")

💡 Detailed month and year format explained here

Convert date to text in Google Sheets

How to convert date to text in Google Sheets?
Convert date to text in Google Sheets

CONVERT DATE TO TEXT — GOOGLE SHEETS FORMULA AND EXAMPLE

=TEXT(A2,"dd/mm/yyyy")

💡 Detailed month and year format explained here