Weekdays of the month.
If the start date is in cell A1, put this formula in cell A2 and drag down:
=IF(WEEKDAY(A1)<6,A1+1,A1+3)
in cell B1, put the formula =A1 and format as "ddd" and drag down
Regards
Trevor
"Dean" wrote in message
...
Am using Excel 2007 and I want to create a list of days of the week for a
month as below I can convert the col 2 info based on Col 1. Any idea on
a
formula for creating col 1. A table on another sheet is OK and no problem
re
holidays. I just don't want weekend days shown and can't quite noodle it
out.
Col 1 Col2
8/1/07 Wed
8/2/07 Thu
8/3/07 Fri
8/6/07 Mon
8/7/07 Tue
|