Today is Excel Date 42000

This is day 42000 in the Excel calendar, so maybe we’ll get the “Answer to The Ultimate Question of Life, the Universe, and Everything” – a thousand times!

Day 42000 in Excel http://blog.contextures.com/archives/2014/12/27/today-is-excel-date-42000/

Keyboard Shortcuts

I noticed today’s serial number this morning, while working on my daily reports.

First, I entered today’s date, by typing the keyboard shortcut – Ctrl + ;

date42000a

In the next row, I used a different shortcut, to copy from the row above – Ctrl + ‘

That showed the date as a serial number, which is how Excel stores dates.

date42000b

When is 43000?

As soon as I pressed Enter, the cell showed the date in the Short Date format, which is how that column is formatted.

Finally, a little arithmetic in the next row showed me when it will be 43000 – September 22, 2017. See you then!

date42000c

______________________

You may also like...

12 Responses

  1. Hi Deb,

    You know that you are an Excel person when your response to “What’s the date today?” is “It’s 42000”.
    BTW…Happy 42005!

    Cheers,
    Kevin

  2. MF says:

    Hi Debra,
    Today is 42004; and tmr will be “MMXV”. I wish to take this opportunity to thank you for all the great posts here. I’ve learnt so much from you!
    Happy New Year! Wish you and your family a prosperous new year of 2015!
    Cheers,

  3. Ramki says:

    Hi!!Debra!!
    Happy New Year!!
    Would like to share one more formula for quick success.
    If 43000 in A4, then=Date(Year(A4),Month(A4),Day(A4))..enter.the answer is.22/09/2017..

  4. George says:

    Debra,
    Your solution works, but isn’t it a little convoluted? Why work with date addition? Just enter 43000 in a cell and format the cell as a date.

    I’m a BIG fan of yours and your site; I just think that this time we bypassed the easy solution in favor of a straightforward one. I recognize the syndrome, because I’ve done it LOTS of times!

    Thanks again for all your help, all the time.

    • @George, you’re right, I could have just typed 43000 in that cell, and skipped the formula! I vaguely remember wanting to show a bit of date arithmetic, so that must be why I did it.

      However, I had pneumonia when I posted this article, so maybe the medication was clouding my thinking. ;-)

  5. George says:

    Oops. Should have said “bypassed the easy solution in favor of a more complicated one”. THAT is what I’ve done many, many times.

  6. Ariel says:

    ¡Excellent! ¡Beautiful!

  7. Lysander says:

    Greetings from the future! I was just working with a system which kept saying that the date was ‘43000’, so I had to google it… And here I am, exactly!

Leave a Reply to Kevin Lehrbass Cancel reply

Your email address will not be published. Required fields are marked *