Using Workday function to exclude Holidays and Fridays

[abesimpson]

I am using this formula in a spreadsheet =WORKDAY(M9+-14,-1,Exclude_HolidaysAndFridays)

"HolidaysandFridays" are lists of company holidays, and Fridays.

I was wondering if there was a way of incorporating the weekday function in this formula so as to eliminate having to make the Friday List?

Thanks in advance

a

 

[theBardd]

See if this works for you

=WORKDAY.INTL(WORKDAY(F1-14,-1,holidays)+1,-1,16)

 

[Phuoc]

Or try:

=WORKDAY.INTL(start_date,days,"1111000",holidays)

 

[abesimpson]

See if this works for you

=WORKDAY.INTL(WORKDAY(F1-14,-1,holidays)+1,-1,16)

Works perfectly!! 10^6 thanks.

Would it be too much trouble to explain how it works?

Regards

a

 

[abesimpson]

I realize that I incorrectly framed my question. I am trying to exclude the date if it FALLS on a Friday or a holiday, not to exclude Fridays or holidays from the count back.

 

[theBardd]

Or try:

=WORKDAY.INTL(start_date,days,"1111000",holidays)

I think you have workdays and non-workdays th wrong way around, it should be

=WORKDAY.INTL(A2-14,-1,"0000111",holidays)

 

[theBardd]

I realize that I incorrectly framed my question. I am trying to exclude the date if it FALLS on a Friday or a holiday, not to exclude Fridays or holidays from the count back.

Okay, test for Friday and subtract on if so

=WORKDAY(A2-14,-1,holidays)-(WEEKDAY(WORKDAY(A2-14,-1,holidays),1)=6)