enter days and dates

  • Thread starter Thread starter cpliu
  • Start date Start date
C

cpliu

I've used Fill handle to add all the dates of 2009 in cloumn A.
1) How do I enter all the days (Mon, Tue, etc) in Column B based on
column A?
2) What to do if I want only the weekdays in column A?

Thanks for the help,
 
1) =A1, format as ddd
Thanks for the quick help. The first one works, but I'm not sure about
the answer to 2). I got them change into Sun, Mon, Tue etc like the
answer for 1. What I want is to have for example 1/12/2009 (Mon) to
1/16/2009 (Fri) and jump over Sat and Sun and continue with other
weekdays. Any other way?

To expand from my question, is it possible to add a border on top of
all the Mondays so I can visually see the weeks?

Thanks for the help,
 
I don't know about Excel 2003, but in Excel 2007 you can do this:

Put a date in a cell. Extend the selection and use Edit>Fill>Series:Weekdays
 
Back
Top