@p45cal:

For the confirmation, thank you Pascal.

Reference:

"Application.Transpose will convert dates to strings then leave it to the sheet to re-interpret strings to dates. If you're not in a month/day/year locale version of Excel it'll interpret wrongly."

This seems true in USA locale version (m/d/yyyy) as well. Thank you much for that as well. I would not have expected the conversion to strings.

Mark