Additional parameters using the WORKDAY.INTL function

[tobysdhc]

Hello,
I am using the following formula to determine a due date (you have 60 days to complete the assignments including weekends and excluding holidays)

=WORKDAY.INTL(A1,60,"0000000",C1:C9)
A1 = start date
60 = number of day to complete the assignment
“0000000” = every day is included (no weekends)
C1:C9 = list of holidays

Using the parameters above I get the date “dddd, mm/dd/yyyy”

Here is my dilemma, the due day cannot be a Saturday or a Sunday. If the due date falls on a Saturday or Sunday I need to automatically go back to the previous Friday. For example, is the due date lands on “Saturday, 10/24/2015” or “Sunday 10/25/2015” I need the due date to display as “Friday, 10/23/2015”

Your thoughts?

 

[DRSteele]

What do you want to do if our formula reports a date that is in the Holiday list, which is bound to happen? Which do you want Friday January 01, 2016 to become, Dec31 or Jan2?

Even then, Jan2 is a Saturday, which would then become Jan1 a Holiday....we're going in circles here!

 

[tobysdhc]

If possible 12/25 and 1/1 would be due 12/18. 11/27 would be due on 11/20. Basically, it would be the Friday before that isn't a holiday.

 

[Jonmo1]

Here's an easier way to do the original issue.
If the resulting date is a Sat/Sun go back to previous friday..

=WORKDAY(WORKDAY.INTL(A1,60,"0000000",C1:C9)+1,-1,C1:C9)

 

[Jonmo1]

The absences will go in D5 - up to 8 no changes 9 or more the due date is adjust one day for each absence over 8 with that same weekend rule as above.

Try
=WORKDAY(WORKDAY.INTL(A1,60+MAX(0,D5-8),"0000000",C1:C9)+1,-1,C1:C9)