Excel Date Format Shortcut

Excel Date Format Shortcut. In this video, you will learn how to use a handy excel date shortcut to format dates. This shortcut is going to prove a real lifesaver for you when you are dealing with a set of long range of dates especially in the situations where you are unaware of the format.

You may sometimes come across set of data where the dates may be in a different format according to that particular location and your location may be different and according to that, you might interpret the date in a different manner.

For example, a date that is written as 03/12/2017 can be really confusing. You can interpret it in both ways, i.e., 12th of March or 3rd of December. This is going to really confuse you and while working with Excel, you sometimes are in a time crunch and you really need to figure that thing quickly without changing the actual standard format that is provided.

Use the technique shown in this video and practice as much as you can in case you get stuck, do not hesitate to write a comment in hello and I’ll be happy to help you with handy Excel shortcuts and much more.

Don’t forget to watch the next video in which I will demonstrate how to calculate the sum of times. I hope you are enjoying the Excel learning series and are making good use of it.

Click on the following button to download the file used in the demo to practice along with us.

Download Practice File

We hope you find this post useful. In case you are stuck and or need help, feel free to drop a comment below or submit your question. Do share it further and add your feedback about the article in the comments section.