Are there any "power" Excel users on this site (besides me)?

I have an Excel challenge - thought I would send it to y'all to see if any of you have any ideas. I did put the question into MR Excel (an Excel Forum), but have stumped everyone there so far....

My Challenge: I need the date of completion starting today, ending 140 days out, counting only workdays (no Holidays) - This is an easy function - here lies the challenge: This company does not work on Fridays. I have figured out the date by excluding Fridays (counted them as Holidays), but thought someone might have a piece of code to help make it an easier function.

The Current Function: =WORKDAY(Todays Date, Number of Days, Holidays)
The Result: 11/6/2006
_________________

Here you go #4.

Use the =WORKDAY function just as you suspected. Then in a spare part of the spreadsheet, create an array of dates that you don't work on:

Use the =DATE(YEAR,MONTH,DAY) function to populate your array
First identify all the holidays without regard to what day they fall on. it just makes it easier to include all holidays. The =WORKDAY function will ignore any that fall on Saturday or Sunday. Don't worry if the holiday falls on a Friday either. the WORKDAY function will not count it twice if it occurs twice in your array.

Then using =DATE enter the first Friday of the year. In the next cell, add one and then spread that for 51 more weeks. Here is an abbreviated example:

NewYears =DATE(2006,1,1) <= Cell B41
MLK-BD =DATE(2006,1,16)
Wash-BD =DATE(2006,2,20)
etc
FirstFriday =DATE(2006,1,6) <= Assume this is in cell B44
............... =B4+1
............... =B5+1 etc for as many weeks as you need

Then code your =WORKDATE function like this:

StartDate =DATE(2006,3,16) <= Cell B3
ProjDuration 100 <= Cell B4
EndDate =WORKDAY(B3, B4, B44:B99)

Here is a link to the WORKDAY Function
_________________
RunnerBiker ¿
"Live in such a way that you would not be ashamed to sell your parrot to the town gossip." - Will Rogers