Output: Using Format Cells to convert serial number to date Using formula to convert serial number to date The Sample box above it will show a preview of the date using the selected type.Īs a result, the serial number will be converted to a date with the specific format “dd/mm/yyyy”.įigure 4.
Choose the preferred date format in Type.In the Format Cells dialog box, click the Number tab and select the Date category.
Select the cell containing the serial number.To convert the number 43466 into date, we follow these steps: Final result: Convert serial number to date Using Format Cells to convert serial number to dateĪs an example, the serial number for Januis 43466. When the result we obtain is in number form, we can convert the serial number into date by following these methods:įigure 1. The serial number “1” refers to January 1, 1900, and serial dates increment by 1 for every day thereafter.Ĭalculations involving dates are possible because Excel treats dates as numbers. Convert serial number to date – ExcelchatĮxcel has a special way of storing dates by assigning serial numbers.
0 kommentar(er)
