how to set a 6-day work week ?

[RobertH]

When I use the WORKDAY function to calculate the next workday with a range of
cells are defined as public holiday. But I find that Saturday and Sunday are
default set as weekend.

How can I change this default (Saturday and Sunday as weekend) to 6-day week
(i.e. Mon - Sat).

 

[Bob Phillips]

Robert,

Here is an array formula provided by Frank Kabel before Christmas that does
this. It uses named fields for the start_date, days and holiday list.

=start_date+IF(days=0,0,SIGN(days)*SMALL(IF((WEEKDAY(start_date+SIGN(days)*(
ROW(INDIRECT("1:"&ABS(days)*10))),2)<7)*ISNA(MATCH(start_date+SIGN(days)*(RO
W(INDIRECT("1:"&ABS(days)*10))),holidays,0)),ROW(INDIRECT("1:"&ABS(days)*10)
)),ABS(days)))

Commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)