Formula to skip holidays
I know it should omit weekends, but for some reason the formula i am using
does not even with the add-in. Maybe there is an error within the formula
that is stopping this?
"David Biddulph" wrote:
WORKDAY shouldn't need a list of weekends. The second (optional) parameter
is a list of holidays. Weekends get omitted anyway.
--
David Biddulph
"DaveAsh" wrote in message
...
Yeah, sorry. I now have the following:
=WORKDAY(E38,VLOOKUP(J38,$D$1:$F$5,2),AA1:AA34)+MO D(E38,1)+VLOOKUP(J38,$D$1:$F$5,3)+(MOD(E38+VLOOKUP (J38,$D$1:$F$5,3),1)TIME(17,0,0))*2/3
(AA1:AA34 are a list of weekends)
....
|