The WEEKDAY function, when referencing a cell containing a date, returns a value from 1 to 7, corresponding to Sunday, Monday, etc. Apply a custom format of DDDD or DDD to display the full spelling of the day or its three-letter abbreviation. Useful for tabulating orders, sales, etc. by day of the week.
- [Voiceover] Knowing day of the week…for certain kinds of data can be really valuable,…think of sales, transactions, shipping, orders, workflow.…We're looking at a worksheet called Weekday.…We want to know the day of the week for these sales.…Maybe this is a company that sells large equipment,…they don't sell every day.…We want to know which day of the week these sales were made.…The function is called Weekday,…left parenthesis,…we're clicking in cell A2,…the answer we get is correct,…but at first we might be saying,…"Well, that's not that helpful."…We can only get the numbers one through seven,…one means Sunday, two means Monday, and so on,…seven is Saturday.…
Ultimately this is a valuable number,…and we might want to work with the numbers,…but it's gonna be a lot easier…if we simply change the display of this.…Let's go to Format Cells,…Control + 1 is a fast way to get there,…you can also do a right click and go to Format Cells,…and what we want to do here is to go to Custom,…and where you see General here in the white panel…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome50s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Identify the day of the week with WEEKDAY