Fill weekdays and non-holidays

[Spencer Hutton]

i have a column of consecutive dates to track a projects schedule. this
formula named NextDay --
'IF(WEEKDAY(F7)=6,F7+3,IF(WEEKDAY(F7)=7,F7+2,F7+1))' is copied down so that
the weekends are omitted. i am trying to have the holidays omitted as well,
but that is where i am stuck. i have a list of the dates of 7 holidays in a
range named HOLIDAYS. can someone help me with a formula that will omit
both weekends and holidays? thanks in advance.

 

[Frank Kabel]

Hi
replace your formula with WORKDAY:
=WORKDAY(F7,1,list_of_holidays)

Note: You must install the Analysis Toolpak Addin for this.

If you can't use the ATP try:
=F7+SMALL(IF((WEEKDAY(F7+(ROW(INDIRECT("1:&1*10))),2)<6)*ISNA(MATCH(F7+
(ROW(INDIRECT("1:"&1*10))),list_of_holidays,0)),ROW(INDIRECT("1:"&1*10)
)),1)