Weekdays of the month.
On 31 Jul, 23:29, Pete_UK wrote:
Assume you put your start date in A1 (not a weekend day) - enter this
in A2:
=IF(WEEKDAY(A1,2)=5,A1+3,A1+1)
and copy down. You can save yourself a column by applying a custom
format to column A as "ddd, m/d/yy" (without the quotes).
Hope this helps.
Pete
On Jul 31, 10:52 pm, Dean wrote:
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
I think you may have missed the OP point, he can sort out Col 2
can convert the col 2 info based on Col 1. Any idea on a
formula for creating col 1
Thus the above may not do what the OP wants, or am I being thick ?
Matthew
|