ForHosting KIT · Developer Utilities

Excel serial number to date

This Excel serial number to date converter takes a single Microsoft Excel 1900-system serial value and returns the matching Gregorian calendar date plus Universal Time clock fields when the serial includes a fractional day.

● BetaFree · in your browser

Run — free How it works & API

Use it from WebAPIEmailTelegramApp soon

Spreadsheet cells often store dates as day counts rather than text: serial one is the first of January nineteen hundred, serial two is the next calendar day, and a fraction such as one half marks noon on that day. Excel inherited a Lotus One-Two-Three compatibility quirk that treats nineteen hundred as a leap year, so serial sixty displays as the twenty-ninth of February nineteen hundred even though that day never existed on the real Gregorian calendar. From serial sixty-one onward the displayed dates again match ordinary history, and well-known anchors include serial twenty-five thousand five hundred sixty-nine for the first of January nineteen seventy and serial forty-four thousand nine hundred twenty-seven for the first of January twenty twenty-three. The engine uses only finite arithmetic with no network calls, no sampling, and no host-clock Date objects, so results stay reproducible in CI, ETL jobs, and product features. Use it free in the browser when you are decoding a cell dump by hand, or call the API at $0.002 per successful request when you need the same contract inside automated pipelines.

How to use it

Enter your values in the form above. The tool checks them before calculating and shows the result on the same page.

Check your inputs

Use the labels and units shown next to each field. If something is missing or outside the allowed range, the page points to the field to fix.

Use it again or automate it

Use the browser tool for individual checks and the API when you need the same capability in an automated workflow.

What you can do with it

Get an answer now

Enter one set of values and see the result without building a spreadsheet or script.

Compare scenarios

Change one value at a time and rerun the calculation to understand what affects the result.

Automate repeated work

Use the API when the same calculation needs to run inside your product or workflow.

FAQ

How do I use this capability?

Complete the fields above and run it on this page. The form highlights anything that needs attention.

For developers — API access

Everything on this page is available programmatically. This section is for teams who want to wire it into their own systems; everyone else can just use the tool above.

API endpoint

POSThttps://api.kit.forhosting.com/date/excel-serial-to-date

Prefer to automate it? One authenticated POST creates the task; the result comes back by webhook or a signed link. The same capability also runs here on the web, by email and from Telegram — and soon from our app too.

Call it from your stack

curl -X POST https://api.kit.forhosting.com/date/excel-serial-to-date \
  -H "Authorization: Bearer $KIT_KEY" \
  -H "Content-Type: application/json" \
  -d '{"serial":44927}'

const res = await fetch("https://api.kit.forhosting.com/date/excel-serial-to-date", {
  method: "POST",
  headers: {
    "Authorization": `Bearer ${process.env.KIT_KEY}`,
    "Content-Type": "application/json"
  },
  body: JSON.stringify({
    "serial": 44927
  })
});
const { task_id } = await res.json();

import os, requests

res = requests.post(
    "https://api.kit.forhosting.com/date/excel-serial-to-date",
    headers={"Authorization": f"Bearer {os.environ['KIT_KEY']}"},
    json={
    "serial": 44927
},
)
task_id = res.json()["task_id"]

<?php
$res = file_get_contents("https://api.kit.forhosting.com/date/excel-serial-to-date", false, stream_context_create([
  "http" => [
    "method"  => "POST",
    "header"  => "Authorization: Bearer " . getenv("KIT_KEY") . "\r\nContent-Type: application/json",
    "content" => '{"serial":44927}',
  ],
]));
$task = json_decode($res, true);

body := bytes.NewBufferString(`{"serial":44927}`)
req, _ := http.NewRequest("POST", "https://api.kit.forhosting.com/date/excel-serial-to-date", body)
req.Header.Set("Authorization", "Bearer "+os.Getenv("KIT_KEY"))
req.Header.Set("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)

Example request

{
  "serial": 44927
}

Example response

{
  "task_id": "tsk_a1b2c3d4e5f6a1b2c3d4e5f6",
  "type": "date.excel_serial_to_date",
  "status": "queued",
  "_links": {
    "result": "/tasks/tsk_…/result"
  }
}

The API is asynchronous: the call returns a task_id immediately and the result arrives by webhook. Polling is capped at 1 req/s per task.

Pricing

Per request$0.002

Published price — no tokens, no invented credits. A failed task is never charged.

Errors

HTTP	Code	Meaning
`401`	`unauthorized`	Missing or invalid API key.
`402`	`insufficient_balance`	Your balance doesn't cover the task price.
`404`	`unknown_type`	That task type doesn't exist.
`429`	`rate_limited`	Too many requests. Use the webhook instead of polling.

Read the full KIT documentation →