Convert Date to Number (or Number to Date) – Excel & Google Sheets
In this Article
This tutorial will demonstrate how to convert a date to a serial number corresponding to the date or a serial number to a date in Excel and Google Sheets
Date to Number
To convert a date to a serial number, all you need to do is change the formatting to General:
However, this won’t work if the date is stored as text.
Date Stored as Text to Number
If the date is stored as text, you can use DATEVALUE convert it to an Excel date:
Number to Date
To convert a serial number to a date, all you need to do is the change the formatting from General (or Number) to a date format (ex. Short Date):
Convert Date to Number in Google Sheets
All of the above examples work exactly the same in Google Sheets as in Excel.