Date and time (ISO 8601, UTC) to Excel serial date
Type a value in UTC to get it in Excel instantly.
39857.980208Excel
That moment falls on a Friday, day 44 of 2009 (UTC).
Convert the other way: Excel to UTC
What it means
Where is that on the timeline?
All dates are UTC. Unix time and these counts ignore leap seconds; Excel serials follow the 1900 date system and start at 1 March 1900.
The math
How to convert UTC to Excel
date = 1970-01-01 00:00:00 UTC + timestamp seconds. Excel serial = Unix ÷ 86,400 + 25,569; Julian Date = Unix ÷ 86,400 + 2,440,587.5.
Example: 2009-02-13 23:31:30 UTC = 39857.980208 Excel.
Every unit
That moment in every format
Tables
UTC to Excel conversion table
| UTC | Excel |
|---|---|
| 2000-01-01 00:00:00 UTC | 36526 Excel |
| 2001-09-09 01:46:40 UTC | 37143.074074 Excel |
| 2004-11-09 11:33:20 UTC | 38300.481481 Excel |
| 2008-01-10 21:20:00 UTC | 39457.888889 Excel |
| 2011-03-13 07:06:40 UTC | 40615.296296 Excel |
| 2014-05-13 16:53:20 UTC | 41772.703704 Excel |
| 2017-07-14 02:40:00 UTC | 42930.111111 Excel |
| 2020-09-13 12:26:40 UTC | 44087.518519 Excel |
| 2023-11-14 22:13:20 UTC | 45244.925926 Excel |
| 2027-01-15 08:00:00 UTC | 46402.333333 Excel |
| 2030-03-17 17:46:40 UTC | 47559.740741 Excel |
| 2033-05-18 03:33:20 UTC | 48717.148148 Excel |
| 2038-01-19 03:14:07 UTC | 50424.134803 Excel |
Excel to UTC conversion table
| Excel | UTC |
|---|---|
| 36526 Excel | 2000-01-01 00:00:00 UTC |
| 37143 Excel | 2001-09-09 00:00:00 UTC |
| 38300 Excel | 2004-11-09 00:00:00 UTC |
| 39458 Excel | 2008-01-11 00:00:00 UTC |
| 40615 Excel | 2011-03-13 00:00:00 UTC |
| 41773 Excel | 2014-05-14 00:00:00 UTC |
| 42930 Excel | 2017-07-14 00:00:00 UTC |
| 44088 Excel | 2020-09-14 00:00:00 UTC |
| 45245 Excel | 2023-11-15 00:00:00 UTC |
| 46402 Excel | 2027-01-15 00:00:00 UTC |
| 47560 Excel | 2030-03-18 00:00:00 UTC |
| 48717 Excel | 2033-05-18 00:00:00 UTC |
| 50424 Excel | 2038-01-19 00:00:00 UTC |
Quick answers
Quick answers
- How many Excel is 1970-01-01 00:00:01 UTC?
- 1970-01-01 00:00:01 UTC is 25569.000012 Excel.
- How many Excel is 1970-01-01 00:00:10 UTC?
- 1970-01-01 00:00:10 UTC is 25569.000116 Excel.
- How many Excel is 2009-02-13 23:31:30 UTC?
- 2009-02-13 23:31:30 UTC is 39857.980208 Excel.
The units
About these units
Date and time (ISO 8601, UTC) (UTC)
The date written as year-month-day and time, in UTC.
Excel serial date (Excel)
Days since 30 December 1899, as Excel and Google Sheets store dates.
Keep going