convertimate Unix timestamp

Excel serial date to date and time (ISO 8601, UTC)

Type a value in Excel to get it in UTC instantly.

2009-02-14 00:00:00UTC

That moment falls on a Saturday, day 45 of 2009 (UTC).

Convert the other way: UTC to Excel

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 Excel to UTC

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: 39858 Excel = 2009-02-14 00:00:00 UTC.

Every unit

That moment in every format

Tables

Excel to UTC conversion table

Excel to UTC conversion table
ExcelUTC
36526 Excel2000-01-01 00:00:00 UTC
37143 Excel2001-09-09 00:00:00 UTC
38300 Excel2004-11-09 00:00:00 UTC
39458 Excel2008-01-11 00:00:00 UTC
40615 Excel2011-03-13 00:00:00 UTC
41773 Excel2014-05-14 00:00:00 UTC
42930 Excel2017-07-14 00:00:00 UTC
44088 Excel2020-09-14 00:00:00 UTC
45245 Excel2023-11-15 00:00:00 UTC
46402 Excel2027-01-15 00:00:00 UTC
47560 Excel2030-03-18 00:00:00 UTC
48717 Excel2033-05-18 00:00:00 UTC
50424 Excel2038-01-19 00:00:00 UTC
UTC to Excel conversion table
UTC to Excel conversion table
UTCExcel
2000-01-01 00:00:00 UTC36526 Excel
2001-09-09 01:46:40 UTC37143.074074 Excel
2004-11-09 11:33:20 UTC38300.481481 Excel
2008-01-10 21:20:00 UTC39457.888889 Excel
2011-03-13 07:06:40 UTC40615.296296 Excel
2014-05-13 16:53:20 UTC41772.703704 Excel
2017-07-14 02:40:00 UTC42930.111111 Excel
2020-09-13 12:26:40 UTC44087.518519 Excel
2023-11-14 22:13:20 UTC45244.925926 Excel
2027-01-15 08:00:00 UTC46402.333333 Excel
2030-03-17 17:46:40 UTC47559.740741 Excel
2033-05-18 03:33:20 UTC48717.148148 Excel
2038-01-19 03:14:07 UTC50424.134803 Excel

Quick answers

Quick answers

How many UTC is 39858 Excel?
39858 Excel is 2009-02-14 00:00:00 UTC.

The units

About these units

Excel serial date (Excel)

Days since 30 December 1899, as Excel and Google Sheets store dates.

Date and time (ISO 8601, UTC) (UTC)

The date written as year-month-day and time, in UTC.

Learn more about moment units

Keep going

Related conversions