Auto input days of week
If column A contains a calculated date that Excel recognizes as a date,
you can either...
1. Format the date cells in column A to show the day name as well as
the date, or
2. Add a formula to the cells in column B that simply reference column
A, then custom format that cell with "ddddd" to show the day only in
that column.
|