Well first off, what’s the convert function? The convert function is used to change data from one unit to a different type in Excel. It’s most commonly used for date conversions, and surprisingly, ...

These serial numbers constitute Excel's internal storage format for date entries. For example, "2012" entered into a date-formatted cell becomes July 5, 1909 in Excel for the Mac and July 4, 1905 ...