using System.Globalization;
public static void Main()
string exceldate = "11/29/2017";
DateTime date1 = new DateTime();
date1 = DateTime.ParseExact(exceldate, "MM/dd/yyyy", null);
Console.WriteLine(date1);
string SentDateString = date1.ToString("yyyy/MM/dd");
Console.WriteLine(SentDateString);