How Excel Stores and Formats Dates

Опубликовано: 08 Август 2026
на канале: Danny Rocks
8,840
32

During the past 2 weeks, I received at least 25 questions from my viewers concerning problems they were experiencing while working with Dates in Excel.

With this in mind, I created this tutorial to answer as many of these common questions as I can. In my opinion - and from my experience - a high percentage of Excel users do not completely understand how Dates and Times are stored in Excel.

By the end of this tutorial, you should have a firm understanding of how to enter Dates so that they are stored correctly. Then, you can use the techniques that I demonstrate to format the Dates to suit your needs and your regional preferences.

As much as I would like to , I CANNOT respond to each individual request. I try to group several requests together to teach a concept that will help as many of my viewers as possible to learn more about MS Excel.

I encourage you to visit my secure, online shopping site - http://shop.thecompanyrocks.com - to learn about the many training resources that I offer!

Danny Rocks
The Company Rocks