We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
ExcelDateToDateList[t] converts date number from imported Excel sheet to DateList format.
ExcelDateToDateList[x_]:= (DatePlus[{1900, 1, 1}, x - 2]);
Example:
ExcelDateToDateList[41684] {2014, 2, 14}