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