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).

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((WEEKD AY(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(I NDIRECT("1:"&ABS(days)*10)
)),ABS(days)))

Commit with Ctrl-Shift-Enter.

--

HTH

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


"RobertH" wrote in message
...
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).