Hi There

You could try using cdate rather than formatting the date i.e.

..cells(ml_TARGET_ROW, 10).Value = CDate (rs_SOURCE("Period end"))
'where the data in the parenthesis is your date

Hope this helps

Steve