Excel TEXT Function to Display Date in Formula
Don't miss that in Excel when you want to reference a date in another column (that is formatted as a date, not as text) in a formula in another cell and display it in the correct date format, you can use the TEXT function.
In this example we see that when a reference is made to a date in a formula using a simple cell reference, we get the date converted to a number.
If instead the formula is written using the TEXT function:
="Letter dated, "&TEXT(A2,"mm/dd/yyyy")
. . . the date will be shown in the result of formula.