Excel Serial Date to Calendar Date screenshot

Excel Serial Date to Calendar Date

Convert an Excel or spreadsheet serial day number into a calendar date, with the 1900 leap-year quirk handled.

Privacy First
0 Runs
Updated 2026-11-22
Runs in your browser
States its rule
Nothing uploaded

What this Excel Serial Date to Calendar Date calculator does

Convert an Excel or spreadsheet serial day number into a calendar date, with the 1900 leap-year quirk handled.

Serial 1 is 1 January 1900 in the 1900 date system, and serials from 61 upward are one day ahead of a naive count because the original spreadsheet treated 1900 as a leap year. Serial 60 is that fictitious 29 February 1900 and is refused rather than mapped to a real day. Dates before 1900 are out of range here.

How to use it

Enter Serial day number, then press Calculate. The page recalculates as you type and runs the same operation again from the values on screen.

Worked example

Input:

Serial day number = 46348

Output:

Calendar date = 2026-11-22
Weekday = Sunday
Days since 1 January 1900 = 46347

Why it runs in your browser

Every date is read as a civil date in this browser's local time zone: the page carries no time-zone database and no locale data, and nothing you type is sent anywhere.

Excel Serial Date to Calendar Date: Convert an Excel or spreadsheet serial day number into a calendar date, with the 1900 leap-year quirk handled.

Serial 1 is 1 January 1900 in the 1900 date system, and serials from 61 upward are one day ahead of a naive count because the original spreadsheet treated 1900 as a leap year. Serial 60 is that fictitious 29 February 1900 and is refused rather than mapped to a real day. Dates before 1900 are out of range here.

Worked example: Serial day number = 46348 gives Calendar date = 2026-11-22; Weekday = Sunday; Days since 1 January 1900 = 46347.

How to use the Excel Serial Date to Calendar Date calculator

Enter Serial day number, then press Calculate. The page recalculates as you type and runs the same operation again from the values on screen.

Every date is read as a civil date in this browser's local time zone: the page carries no time-zone database and no locale data, and nothing you type is sent anywhere.

  • Serial day number — a whole number

The rule this page applies

Serial 1 is 1 January 1900 in the 1900 date system, and serials from 61 upward are one day ahead of a naive count because the original spreadsheet treated 1900 as a leap year. Serial 60 is that fictitious 29 February 1900 and is refused rather than mapped to a real day. Dates before 1900 are out of range here.

A year is a leap year when it is divisible by 4, except a century, which is a leap year only when divisible by 400. February therefore has 29 days in 2028 and 28 in 2026, and the page reads the real month length rather than a table.

  • Calendar date = 2026-11-22
  • Weekday = Sunday
  • Days since 1 January 1900 = 46347

What to Expect

Best for

  • Checking a date by hand
  • Getting the calendar date quickly
  • Comparing two candidate dates

Not ideal for

  • Statutory holiday calendars
  • Time-zone conversion
  • Locales other than English

What this tool keeps

  • Your inputs in this tab
  • The rule, printed in full
  • The same answer on every run

What may need cleanup

  • A date the page refuses, which names the reason instead of guessing
  • A count outside the supported range, which is refused by name

Common errors

  • A date that does not exist, such as 30 February, is refused rather than rolled forward
  • A blank field is refused rather than read as today
  • A written date in an order the page does not accept is refused by name

Example use cases

  • Planning around a deadline
  • Checking a date before you commit to it
  • Homework and exam checking

Sample input

Serial day number = 46348

Sample output

Calendar date = 2026-11-22; Weekday = Sunday; Days since 1 January 1900 = 46347

Who this is for

  • Anyone checking a date by hand
  • Students and teachers

Frequently asked questions

What does the Excel Serial Date to Calendar Date calculator do?

Convert an Excel or spreadsheet serial day number into a calendar date, with the 1900 leap-year quirk handled. The page prints calendar date, weekday, days since 1 january 1900.

How does this page count days?

Serial 1 is 1 January 1900 in the 1900 date system, and serials from 61 upward are one day ahead of a naive count because the original spreadsheet treated 1900 as a leap year. Serial 60 is that fictitious 29 February 1900 and is refused rather than mapped to a real day. Dates before 1900 are out of range here.

How are leap years handled?

A year is a leap year when it is divisible by 4, except a century, which is a leap year only when divisible by 400. February therefore has 29 days in 2028 and 28 in 2026, and the page reads the real month length rather than a table.

Which time zone does the page use?

Every date is read as a civil date in this browser's local time zone: the page carries no time-zone database and no locale data, and nothing you type is sent anywhere.

Why is serial 60 refused?

Because it stands for 29 February 1900, a date that never existed. Spreadsheets kept it for compatibility with an early bug, and mapping it to a real day would print a date the number does not mean.

Which date system is assumed?

The 1900 system, which is the default in Excel and most spreadsheet programs. The 1904 system used by some older Mac files is a different numbering and is not what this page reads.

Developer program

Build custom tools for your store

Join the SDK program to create useful ecommerce utilities for your store.