What Are Date and Time Serial Numbers in Microsoft Excel, and Why Do They Exist?
Date and time calculations would be impossible without them.
In Microsoft Excel, if you select cells containing a date or time and apply the General number format, this generates what appear to be random numbers. In fact, these numbers are anything but random—they're sequential serial numbers that serve a specific purpose.
