Learn to use the WEEKDAY function to determine the day of week for any given date. Also, learn to apply a Custom Format to display the day however you want.
- [Instructor] It's not uncommon to work with data…and want to know the day of the week.…For example, sales data, order data, shipping data.…In this worksheet called Weekday,…we will be using a function called weekday…that allows us to figure out which day of the week…this particular day and all the others are.…The function is equal weekday.…Looking at the data here in cell B2.…Two?…Well, two means Monday.…One means Sunday, three means Tuesday, and so on.…Valuable information, and ultimately we might need…to refer to this number later,…but it might be better if we could actually see…which day of the week it is.…
And although the process is not difficult,…it's certainly not obvious what we do next.…We need to go to Format Cells.…A quick way is Control + 1.…And in the Format Cells dialog box,…click the Number tab if it's not already selected,…then choose Custom, and in the upper panel…where you see the word General, select it and type…three D's to get the display M-O-N.…You see the preview up above for Monday,…or four D's to spell out the day of the week if you wish.…
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.