Convert Excel/OADate timestamp to human-readable date
Excel OLE Automation Date or OADate (or Serial Date) is a date and time representation used in Microsoft Excel and other applications. It is the number of days that have elapsed since December 30, 1899, with January 1, 1900 being the first day. Fractional values represent the time of day.
Note: Excel has a known bug where it treats 1900 as a leap year, adding a fake February 29, 1900 to its calendar. This is why OADate starts from December 30, 1899 to keep values in sync with Excel.
The current Excel OADate timestamp is 46096.698125
Enter your Excel timestamp below:
Displaying the timestamp in Excel
In Excel, you can convert an OADate value to a human-readable date using the TEXT function. For example, if your OADate value is in cell A1, you can use the following formula to display it as a date:
=TEXT(A1, "yyyy-mm-dd hh:mm:ss")
This formula will convert the OADate value in cell A1 to a date format.
You can also change the field-type of the cell to "Date" and apply a date format to display the OADate value as a date.
More
- For days since 1900 (where Jan 1 is day 0), use the Days Since 1900 Converter.
- For days since 1904 (used by Excel on older Apple devices), use the Days Since 1904 Converter.
The difference is 1462 days, an OADate timestamp of 0 in the 1900 system corresponds to -1462 in the 1904 system.