How to include dates into my mail merge or why are dates incorrectly formatted?

Excel processes dates in a numeric format, so if you try adding a date field the mail merge will include a numeric value instead of the date you expected.

In order to correctly add a date, simply create a new column (e.g. "DateString") and add the following formula (referencing your date column, in this example A2):


Note the exact formula depends on your Excel language settings, see here for details on how to exactly use the function:

This way a new column is created with the date stored as a text and you can configure the way it is displayed automatically (e.g. 14/02/2019 or 2019-02-14 or 14th Feb).

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us