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