Learn to use the letters d, m, and y in a variety of combinations to create your own date formats.
- [Instructor] In addition to the many built-in formats…that you have available to you in Excel…for formatting dates and times,…we can also set up our own formats,…by using various combinations of the letters m, d, and y.…Nothing truly wrong with the dates in column B.…But maybe we want to display…the day of the week along with this.…So, by right clicking column B,…and choosing Format Cells,…or by pressing Ctrl + 1,…we can go to the Format Cells dialog box.…You don't necessarily have to go to the date tab first.…
There are all the built-in variations.…Maybe the one you're looking for…you're not sure is a built-in?…Well, maybe not.…So, let's go to Custom.…And you're likely to see,…if you have just come from the Date category,…already m, d, y, y kind of display the way we see here.…But let's use this in some variations.…For example, I'm going to say I want the day of the week.…Now I could put in ddd.…That will display, for example,…TUE, WED, THU, that sort of thing.…
So if I want to spell out day of the week…I'll put in four d's.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- How Excel records and stores dates
- Using standard date/time entries and acceptable alternatives
- Formatting dates and times
- Creating standard date/time formats
- Working with dates and times in functions
- Calculating with dates and times
- Using dates/times with Excel commands
Skill Level Intermediate
1. Understanding the Excel Date/Time System
2. Creating Date/Time Entries
3. Formatting Dates and Times
4. Working with Dates and Times in Functions
5. Calculating with Dates and Times
6. Using Dates/Times with Excel Commands
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.