Chapter 3: Dates and odd displays
Exercise 11: Add the weekday to dates
Task
Show the schedule dates as "11/2 (Mon)".
Moves 0 (target 1)4 difference(s) from the model
File
Font
Alignment
Number
Styles
Cells
A1Press and release Alt to show KeyTips (Windows). Ctrl + 1 opens Format Cells, Ctrl + Z undoes.
| A | B | C | |
|---|---|---|---|
| 1 | Date | Event | |
| 2 | 2026/11/2 | Weekly meeting | |
| 3 | 2026/11/4 | Visitor | |
| 4 | 2026/11/7 | Training | |
| 5 | 2026/11/9 | Deadline | |
| 6 | |||
| 7 |
Show the schedule dates as "11/2 (Mon)".
This drill is for computer screens. On a phone you can review the steps.
- Select A2:A5
- Ctrl + 1 > Number > Custom
- Enter m/d (ddd) in Type and click OK
Key takeaway
ddd shows the short day name (Mon), and dddd shows the full name (Monday).
See custom number formats for details.