Determining physical date after adding 6 day week + allowing for holidays

[bundyanimal]

Hi,

Please refer to the attached xls file.

Basically, I am setting up an Extension Of Time Register and need to find out the revised date for completion of an activity.

The cell I25 (Tab 1) currently works out the finish date from a physical commencement date as well as a project duration (taking into account a 6 day work week).

This is all good so far hopefully.

Now what I want to do, dependent on when the contract commences, I want it to take into account the public holidays and CPB days off that is showed in Tab 2.

(i.e, if the Contract, commences on 3/04/18 and is to be completed by 20/05/18, I want it to add to the formula in I25 these additional holidays. (i.e. Wednesday, 25 April 2018 and Monday, 7 May 2018) (as these are non work days and need to be added to the completion date)

[Aardigspook]

An easier solution than the formula you have in I25 would be to use WORKDAY.INTL. This formula will give you the same result as what you have:

Please Login or Register  to view this content.

If you then put your holidays in another range somewhere (let's say A48:A49), you can use something like this to take them into account as well:

Please Login or Register  to view this content.

[bundyanimal]

Sorry for not getting back sooner.

Thanks very much fro your prompt response and suggested solution.

It works a treat.

Thanks.

[Aardigspook]

You're welcome and thanks for the feedback.

If that's your problem taken care of, please take a moment to mark to mark the thread as Solved so others know there's an answer here (see instructions in my sig). Thanks.