Reading dates in excel return random numbers not the date

[prasath17 (Guru)]

@Macklin_J - Please check this post…(if you feel preserve format will slow down your process)

Convert string format date to the Date format

Hi @shandilya.suthar15 Try this: DateTime.FromOADate(Convert.ToDouble(row(“yourcolumnname”).ToString)).ToString(“MM/dd/yyyy”)