Trying to use an Excel Date and Time function, but Excel returns a serial number instead of date; this is because Excel stores dates and times in serial numbers in the backend; for instance, when ...

For example, "2012" entered into a date-formatted cell becomes July 5, 1909 in Excel for the Mac and July 4, 1905, under Windows. That's because the Excel for the Mac treats January 2, 1904, as ...