Check if an excel cell is formatted as a date

[Anil_G (Anil Gorthi)]

Hi @ctkoh

To be exact with your format.please use this

DateTime.TryParseExact((“Excel date string”, “dd/MM/yyyy hh:mm tt”, System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, Nothing)

And for formatting you can use format cell

Cheers