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

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

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,

2. ## Re: Workday function for 7 day work week (only observing holidays)

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]

3. ## Re: Workday function for 7 day work week (only observing holidays)

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

4. ## Re: Workday function for 7 day work week (only observing holidays)

Worked perfectly. Thank you very much.

There are currently 1 users browsing this thread. (0 members and 1 guests)