How to Use Date and Time Serial Numbers in Excel Calculations Now that you know how serial numbers work for dates and times in Excel, you're ready to make the most of this knowledge in calculations.

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.