Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to convert a serial number to a date in Excel and Google Sheets
Excel & Google Sheets
=TEXT(A2,"YYYY-MM-DD")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Serial Number | Date |
| 45297 | |
| 45383 | |
| 44927 | |
| 45658 |
=TEXT(A2,"YYYY-MM-DD")→2024-01-06
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1If the serial number is already in a cell (e.g., A2 contains 45297), select the cell and change its format to Date — no formula needed.
- 2To convert and display as text, use =TEXT(A2,"YYYY-MM-DD") in B2.
- 3To keep it as a date value for further calculations, format A2 as Date (Ctrl+1 > Date in Excel or Format > Number > Date in Sheets).
- 4Note: Excel's date system starts at 1 = January 1, 1900; Sheets also defaults to 1900 (but can use 1904 system).
Tips
- If you're pasting serial numbers that look like 5-digit integers, just format the cell as Date — no formula required — and the number will render as a date.
Need it for your exact data?
Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.
Frequently asked
Why does my date show 1904 when I expect a 2024 date?
The 1904 date system may be enabled. In Excel: File > Options > Advanced > uncheck 'Use 1904 date system'. In Sheets it defaults to 1900.
What does serial number 1 equal?
In Excel's 1900 system, serial 1 = January 1, 1900. Serial 45297 = January 1, 2024.