Excel Tricks with Tejraj

In this blog post we will learn in detail about “Date Format in Excel”. There are many instances when we need to use dates in excel. If we know how to use Date Formats in excel then we can work very easily with the dates. In our previous blog post we have seen 03 methods to go to additional options of formatting cell values . If you missed to read those methods, please click here before going for this blog post. We can use any of these 03 methods to get the “Format Cells” dialog box and select “Date” Category as shown in below image. With this we can see all the additional options under “Date Format” in excel as shown in below image: Sample: This option is common in all the formats which we can see under Date Category in above image which we can use to see how the selected numbers will look in Date Format. Locale (Location): This option will convert the date into selected language based on a country. Type : We can choose any of the desired format under this option. The type which ...