View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default 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.