IF formula remove weekends and holidays

[wheellp]

I am looking for a formula so that if a a date is a holiday or weekend, it will subtract days until it reaches a non-weekend or non-holiday but if it's not a weekend or holiday to keep the original date. Can someone help me with this please?

 

[Tetra201]

Try using the WORKDAY function:

=WORKDAY(A1+1,-1,List_of_Holidays)

 

[wheellp]

Is there any special format that the list of holidays has to be in? I couldn't get it to take the list of holidays i made in column C

 

[FDibbins]

How did you list the holidays?

 

[Tetra201]

The list can be either a range of cells that contain holiday dates or an array constant, for example:

=WORKDAY(A1+1,-1,C1:C10), or

=WORKDAY(A1+1,-1,Holidays), where Holidays is a name that refers to C1:C10, or

=WORKDAY(A1+1,-1,{"2017-03-30","2017-03-31"}), or

=WORKDAY(A1+1,-1,{42824,42825})