how to set a 6-day work week ?

[Guest]

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)

 

[baddipu]

6 day working day

Hi, the foll formula shows an error - "#Name?" for me, any suggestions.

=A1+IF(days=0,0,SIGN(10)*SMALL(IF((WEEKD AY("A1"+SIGN(10)*(ROW(INDIRECT("1:"&ABS(10)*10))),2)<7)*ISNA(MATCH("A1"+SIGN(10)*(ROW(INDIRECT("1:"&ABS(10)*10))),holidays,0)),ROW(INDIRECT("1:"&ABS(10)*10))),ABS(10)))