Exactly WHY won't it work? Holidays is simply a list of days off in addition
to Saturdays and Sundays.

On Wed, 9 Feb 2005 09:43:05 -0800, "Aviator"
wrote:

That is not going to work in this situation. Do you have any other ideas?



"Bernie Deitrick" wrote:

Aviator,

Simplest would be to add every Friday to your list of holidays....

HTH,
Bernie
MS Excel MVP

"Aviator" wrote in message
...
I was trying to use the following formula to come up with a date 40 work
days
prior to the date specified in cell AN2. The following formula works
great
except I work 4X10's (Mon - Thur) and this formaula is counting Friday.

=IF(AN2="","",WORKDAY(AN2+(WEEKDAY(AN2)=5),-40,holidays))

Is there a variation of this formula that will do the same thing except
just
count Mon thru Fri?

Or is there a better formula that will take care of my problem?

Thank you,

Aviator