Convert the date from a string to a date time for use either in comparison or write into Excel Spreadsheet.
The syntax to use is:
DateTime.ParseExact(DateString, new String() {"dd/MM/yyyy","dd/M/yyyy"}, System.Globalization.CultureInfo.CurrentCulture, System.Globalization.DateTimeStyles.None)