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.
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.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.