can excel schedule a six day work week?

[Guest]

workday function will skip sat and sun. How do I skip only sunday?

 

[Frank Kabel]

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):

=start_date+SMALL(IF((WEEKDAY(start_date+days*(ROW(INDIRECT("1:"&days*1
0))),2)<=6)*ISNA(MATCH(start_date+(ROW(INDIRECT("1:"&days*10))),holiday
s,0)),ROW(INDIRECT("1:"&days*10))),days)

 

[Guest]

Thanks for the help. I am not skilled enough to know how to apply this
solution without further explanation. Is this entered on a cell by cell
basis after the workday function? My project managment schedule works in a
column by adding or subtracting days from the cell above as the project
progresses. A typical cell entry might be "=workday(c23,2,holidays)", where
the value of c23 might be a start date of 1/1/04 and holidays is a named
range with standard holiday dates for 2004 in it. This nicely skips
saturdays and sundays as a work days. However, I must now accelerate and
work on Saturdays on a regular basis. How do I continue forward with my
schedule now recognizing Saturdays, but not Sundays as a work day?

Many thanks for help.

 

[Frank Kabel]

Hi
so instead of
=workday(c23,2,holidays)

use the formula:
=C23+SMALL(IF((WEEKDAY(C23+2*(ROW(INDIRECT("1:"&2*10))),2)<=6)*ISNA(MAT
CH(C23+(ROW(INDIRECT("1:"&2*10))),holidays,0)),ROW(INDIRECT("1:"&2*10))
),2)

and enter this with CTRL+SHIFT+ENTER in a cell. This is a formula which
belongs in a single cell