Workday function for 7 day work week (only observing holidays)

**Alann** · 05-09-2012, 11:14 AM

Hi all,

I have been trying to tackle this from several different angles with no luck. I am trying to use the workday function or something similar to calculate a date after a number of working days say 100. The workday function however, and even the workday.intl forces you to choose at least one weekend day. I would like to do this with holidays being the only days off and every other day being a working day. Would appreciate any feedback.

Thanks,

**daddylonglegs** · 05-09-2012, 11:29 AM

You can specify that all days are working days with WORKDAY.INTL, using "0000000" as the weekend days string, e.g.

=WORKDAY.INTL(A2,100,"0000000",H$2:H$100)

that adds 100 working days to A2 excluding only the holidays specified in H2:H100 [untested]

**daddylonglegs** · 05-09-2012, 11:42 AM

.....or this "array formula" should give the same result in earlier versions

=SMALL(IF(COUNTIF(H$2:H$100,ROW(INDIRECT("1:"&B2*10))+A2)=0,ROW(INDIRECT("1:"&B2*10))),B2)+A2

confirmed with CTRL+SHIFT+ENTER

A2 start date, B2 days to add and H2:H100 holiday range