Have you tried setting the number format of the cells (or columns or rows) which contain your date data to one of the built in excel date formats such as vbShortDate or vbLongDate?

FormatDateTime(cells(x,y), vbShortDate
This may solve your problem