Try
ExcelApp.Cells(j, k + 1) = Date.Parse(frmReportWizard.dgvData.Item(l, i).Value)
Of course I am assuming you have set up your datagridview correctly.
Look carefully at what @OriginalGriff is telling you in Solution 1 and the subsequent comment
- Strings should not be used for dates
- The
Format[
^] function returns a string
- The
DateTime.Parse Method [
^] returns a DateTime. Interestingly I thought that
date.Parse
was Javascript not VB.NET
If you absolutely insist on using strings then use the yyyy-MM-dd or yyyy-Mmm-dd format so there is no ambiguity