Date in mail merge

[SanjayaGarg]

Dear all

I have a mail merge word document which fetches its data from excel sheet and shows date format correctly after adding switch <\@ "dd/MM/yyyy"> in date field of word documents. Now the problem arise when data is fetched from a cell where date is calculated,
e.g.

	A	B	C	D
1	TENURE	DOJ	DUE DATE	FORMULA IN C2
2	44	16-05-2020	29-06-2020	=DATE(YEAR(B2),MONTH(B2),DAY(B2)+A2)

When date field is merged from C2, date is shown as numbers even after adding switches.

Can this be rectified.

 

[johnny51981]

Try changing it to a text format.

=TEXT(C2,"DD-MM-YYYY")

 

[SanjayaGarg]

Try changing it to a text format.

=TEXT(C2,"DD-MM-YYYY")

Try changing it to a text format.

=TEXT(C2,"DD-MM-YYYY")

Try changing it to a text format.

=TEXT(C2,"DD-MM-YYYY")

Try changing it to a text format.

=TEXT(C2,"DD-MM-YYYY")

Dear Johnny, where to use this formula, in excel or mail merge document? In excel I am getting correct value. Problem is when it is fed in mail merge. Please clarify.

 

[johnny51981]

Dear Johnny, where to use this formula, in excel or mail merge document? In excel I am getting correct value. Problem is when it is fed in mail merge. Please clarify.

Hi @SanjayaGarg
The formula would be in the Excel file. Then you would reference the column that the Text formula is in when you create your mail merge. The issue is that when the original date formula is referenced by the mail merge, Word will convert it to the number value (rather than the date).. By converting it to text, in Excel with the suggested formula, Word should recognize the Date as a Text, leaving it in the desired format that you are looking for.