So, the count started from January 1, 1900, and follows through each day until now.īecause June 10, 2019, exactly is 43,627 days after January 1, 1900, the serial number is 43627. That means the serial number 1 appeared on January 1, 1900, the serial number 2 appears the day after, the serial number 3 appear the third day, the serial number 4 appears the fourth day, etc. The series began from January 1, 1900, and every other day since then has always had an addition of one in the serial number form. The Idea of Serial Numbersĭates are stored in excel as serial numbers or integers.

The purpose of this tutorial is therefore to show you different ways by which you can successfully Convert a Serial Number to Date Format in Excel.īefore I show you ways to go about this, I will shed more light on the concept of serial numbers. However, because this date format is somehow hard for humans to comprehend, it is required to convert these number codes (serial numbers) to a familiar date format that can be read by both the user and a third party. It stores dates as numbers and then adjusts them in accordance with the date requirement set by the user.įor this reason, you will want to know how to Convert Serial Numbers to Date in Excel.Īlthough this method of storing data appears counterintuitive, it however is thoughtful because excel can conduct more mathematical operations with dates in numerical form. When importing dates from external sources into Excel, the data often transfers over in a number coded form, such as 42067.Įxcel, which has over 484 functions, has its own way of storing data.

Serial date number