Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

If you enter a year without a month, Microsoft Excel treats it as a number. If you enter the same data in a cell that previously contained a date, Excel treats it as a serial number for a date ...