17. Excel Tips - Date formatting - Show the day of the week

Today's tip is a quick one as I am feeling lazy, but it's a useful one none the less.
- By formatting dates in a certain way, you can display the day of the week, and not using much space.
Step1:
Select A1, and press CTRL + ;
(this gives you today's date)
Step2:
Right click => format cells => custom
type: ddd dd-mmm-yy
For today, you get:
Sat 27-Dec-08
- this is my favourite date format for the following reasons:
1. the "08" is all you need in this century
2. Sat = day of week
3. 27-Dec => it's completely unambiguous and much better than infuriating American date format of: 12/27/2008 (mm/dd/yyyy), as you will find out when it's the 2nd Jan (01/02/2009)... or is it the 1st of Feb ?!
[End of rant]
; - P
Video training on Date formatting:
- Nick's blog
- Add new comment
- 1449 reads

Recent comments
5 hours 30 min ago
8 hours 54 min ago
9 hours 17 min ago
15 hours 19 min ago
16 hours 11 min ago
1 day 6 hours ago
1 day 7 hours ago
1 day 10 hours ago
1 day 18 hours ago
2 days 13 hours ago