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
Watch video How Excel Stores and Formats Dates online without registration, duration hours minute second in high quality. This video was added by user Danny Rocks 27 October 2012, don't forget to share it with your friends and acquaintances, it has been viewed on our site 8,034 once and liked it 31 people.