You've added lots of extra terms after the WORKDAY function. Have you
checked that WORKDAY is doing the wrong thing in isolation? It's always a
good idea to break a long formula into manageable chunks if you need to
debug it.

I don't know quite how your formula is intended to work, but I would have
thought that most of the terms would need to be inside a WORKDAY function to
get the result on the right day. If you are adding an extra term after your
first WORKDAY function and that extra term might take it from one day to
another, then you'll probably need another WORKDAY function to allow that to
step over the weekend.

If your extra terms might give a number of whole days + a time of day for
the finishing point, then perhaps
=WORKDAY(WORKDAY(... first addition ...),INT(extra term))+MOD(extra term,1)
?
--
David Biddulph

"DaveAsh" wrote in message
...
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)
....