Happy Excel Day 45678

Where does the time go? Two years ago, we were celebrating Excel Day 45000, and suddenly it’s Excel Day 45678!

Do you have any special events planned? If not, you could make the office festive, with a few balloons and a magic marker!

excelday45678a

Excel Milestones

We love Excel milestones, here on the Contextures Blog.

• Our first Excel date celebration was Excel Day 40000, way back on July 6, 2009.

• We followed that with a party for Excel Day 42000, on December 27, 2014.

• Somehow, I overlooked Day 43000, but we celebrated Day 44000,

• Another special day was Excel Day 44444.

• Most recently, we celebrated Excel day 45000, on March 15, 2023, almost 2 years ago!

And now it’s Day 45678!

What Day Number Is It?

How did we know it’s day 45678? How can you tell what day number it is in Excel?

First, type any date in an Excel worksheet cell. Or, type this formula, to see the current date:

  • =TODAY()

Then, change that cell to General format, to see the serial number for that date.

In the screen shot below:

  • I typed today’s date in cell E2 – Jan 21, 2025
  • Next, in cell F2, I typed this formula, to link to the date cell:
    • =E2
  • When I formatted cell F2 as General, it showed that today, Jan 21, 2025, is Excel Day 45678.

january 1 2025 formatted in general number format

Consecutive Number Days

Today is a consecutive 5-digit number Excel day – 45678. Those are pretty rare, and exactly 11111 days apart.

The final one is 56789, on June 24, 2055, over 30 years from now.

Will you still be using Excel then?

excelday45678_04

More Excel Day Milestones

As you can see from the list of Excel milestones below, we only have about 11 months to get ready for the next special day:

  • Excel Day 46000 falls on Tuesday, December 9, 2025.

Be sure to mark that day in your calendar, and come back here to celebrate again!

excelday45678_03

Use the TEXT Function

For extra fun and entertainment, you could use a formula to change a number into a date.

  • In a worksheet cell, type a number, between 1 and 2,958,465
  • Next, use the Excel TEXT function to format the number as a date, with a specific format.

In the screen shot below, I used the following formula in cell B4, to show the date with its weekday, month, day, and year.

  • =TEXT(B2,”ddd mmm dd, yyyy”)

There are more TEXT function examples on my Contextures site, and I’ve put a video below, to show more TEXT function formatting examples.

excelday45678_01

Video: TEXT Function Examples

Watch this 3-minute video to see how to combine cells in Excel, with text and number format in the result.

You can get the written steps, and Excel sample file, on the Combine Text and Numbers page, on my Contextures site.

Video Timeline

  • 0:00 Introduction
  • 0:13 Simple Formula
  • 0:52 Add Formatting
  • 1:41 Another Date Format
  • 2:04 Add the Year
  • 2:29 More Formats
  • 3:04 Get the Workbook

Excel Date System Notes

Here are a few notes on formatting numbers as dates in Excel:

  • In Excel, you can format positive numbers in any of the date formats, to see the date that they represent.
  • The Excel 1900 date system uses January 1, 1900 as a starting point – number 1.
  • There is also an Excel 1904 date system, which uses January 1, 1904 as a starting point. That was the default system in old versions of Excel for Mac.
  • The number zero is formatted as January 0, 1900, which is calculated as December 31, 1899
  • The latest date allowed for calculation in Excel is 12/31/9999, which is the number 2958465

Learn more about the Excel date systems on the Microsoft website.

Related Links

Date Function Examples

Excel Date and Time FAQ

Excel Dates Fix Format

_______________

Happy Excel Day 45678

Happy Excel Day 45678

Original source: https://contexturesblog.com/archives/2025/01/21/happy-excel-day-45678/?utm_source=rss&utm_medium=rss&utm_campaign=happy-excel-day-45678

Close Menu