Trying exclude holidays in this argument. Basically if the Holiday falls on the weekday result I need to push the end date to the next weekday or back one weekday.

For example:
=C7+45+LOOKUP(WEEKDAY(C7+45),{1,2,7},{-2,0,-1})

The date in C7 is 7/23/2010 the result is 9/06/2010 which is Labor day. I want the result of 09/03/2010 or 09/07/2010.

Any suggestions on how to add the lookup value for HOLIDAYS in this formula?