Course Content

Course Content

Formatting Date-Time in MS Excel

How to change date and time format


Now we will see that how we can change date and time format in MS Excel.

We can see that on screen we have different type of dates written, like birth date, date of hiring, sales date etc...

As we know that if we want to write date in MS Excel we use '/' or '-' symbol. By default format of date in MS Excel is MM/DD/YYYY.

Suppose if we want the format of the date to be changed according to our need, so for that we will press 'Ctrl+1' and a dialog box of 'Format cell' will get opened, than we can select our desirable date format.

Now if we want our date to be in long format, then we don't need to go to format cell dialogue box, we can change it in HOME tab where we can see a column 'Date'. When we open it we can see that there are number of different formats available there.

Now if we choose long date option then our date will be in the format of 'Day, Month, Date, Year'.

Now suppose if you want the format of date according to our requirement, then we can set the format of date by going in to format cell dialogue box, and writing the format of date which we want in the format column.

If we want to get the date in standard form again, than we will go to the date column and select standard date format.

If we want to view that which particular month it is written in any date by name, then we can select the date and press 'Ctrl+Shift+3' keys.

Now we will talk about time format, suppose we want to change the time which we have written in 24 hour format to 12 hour format, then we can use a shortcut for that, i.e. by pressing 'Ctrl+Shift+2', which will change all the time format into AM and PM.


Excel is a great tool for organizing your work and generating reports. But sometimes it's hard to determine what time it is. With date and time in Excel, you can quickly pick a date format and have the time automatically displayed next to it. you can select the cells you want to format and press Control+1 or Command+1. From there, in the Format Cells box, click the Number tab and choose a date format.

Date and time in Excel have a function to split the dates and times. The DATE function in Excel is for formatting dates in a specific format. There are a few different formats that you can use when your goal is to present and share data in Excel. Date and time in Excel is an important feature for business users. One of the functions in date and time is to split the date into a day, month, year, hour, minute, and second. DATE function: The DATE function takes two parameters - the date and the format. The format parameter has many options, such as "mm/dd/yy", "mm-dd-yy", "mm/dd/yyyy", and "d mm dd yy". You can use it to represent a date that has been formatted by another person or if you want to create your own custom date format. For example, you could create a custom date format with the DATE function like this: =DATE(2015, 3-1)

The date separator is used in various types of documents to separate dates. For example, in a medical record, the date separator separates the day and month. An accountancy document separates the year. Today many people use text editors with built-in date separators; they are typically over one character long and they highlight different days of the week in different colors. Here are different ways that you can go about it. 1) Use the INDEX function for this task 2) Use the MATCH function for this task 3) Use the TEXTJOIN function for this task

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
App Store
397K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
13K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere