Copy Formated Date to Text for Mailmerge

Hi All,

Please help provide what formula or code is required to copy Column "B"(formated dates) to Column "C" as the Text displayed on the screen.

It is possible to copy Column "B" to the clipboard and copy the text back to excel to obtain the required result- as show in column "D", however this is a manual operation that I am trying to overcome (new to VBA and record macro will not work for me).

The Results from Column "C" will be used for a mailmerge into forms/ letters etc. At present the formats from Column "B" (Hijri dates) will not merge as displayed in column "B", only date values are merged and therefore output will be gregorian dates.
The mailmerge forms will have both Gregorian and Hijri dates, so cannot change calender.

Column "A" - Gergorian date- manual input
Column "B" - +Col A (formatted) to display Hijri date
Column "C" - Looking for Col "C" as Text (of column "B" display)

Thanks

Pat