Biff: The method appears to work on my system, please explain the problem.
A3=start date and B3 is the nr. of days.

A3 = 1/9/2007 (Tuesday)
B3 = 11

Result = 1/25/2007 (Thursday)

Correct result should be 1/29/2007 (Monday)

Note there is a little bit of disparity as to when it should end is it to
include today or not?

Workday excludes the start date and includes the end date.

Try that test file I posted. It shows which days should be included. Also
try Ron's udf. It works under "all scenarios".

Biff

"Martin Fishlock" wrote in message
...
Just as a matter of completeness as the OP as already accepted the workday
solution is you test if the start day is a Fri/Sat/Sun and report an
error.

Biff: The method appears to work on my system, please explain the problem.
A3=start date and B3 is the nr. of days.

Note there is a little bit of disparity as to when it should end is it to
include today or not?

Anyway a quick fix to weed out incorrect start dates is to test if the
start
date is

=IF(WEEKDAY(A3,2)4,"Error",A3+INT((B3-1)/4)*7+MOD(B3-1,4)
+IF(OR(WEEKDAY(A3+INT((B3-1)/4)*7
+MOD(B3-1,4),2)<WEEKDAY(A3,2),
WEEKDAY(A3+INT((B3-1)/4)*7
+MOD(B3-1,4),2)4),3,0))

A corresponding change to the macro would also need to be made, but I
leave
that as an exercise.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"T. Valko" wrote:

It still gets tripped up on different scenarios with or without
accounting
for holidays.

Here's a nice test file if you're so inclined.

workday.xls 159kb

http://cjoint.com/?bkamHyKIF8

Input a start date, duration, add/remove holidays.

I still say this is complicated!

Biff

"Roger Govier" wrote in message
...
Hi Biff

I can see that you are correct.
My quick fix of increasing duration *5/4, doesn't account for
completion
occurring on a Friday.
The following amendment fixes the problem (I think - not thoroughly
tested).

=IF(WEEKDAY(WORKDAY(Startdate,(Duration*5/4),holidays))=6,
WORKDAY(Startdate,(Duration*5/4+1),holidays),
WORKDAY(Startdate,(Duration*5/4),holidays)

--
Regards

Roger Govier


"T. Valko" wrote in message
...
Unless I'm missing something, I can't get Rogers or Martins formulas
to
work.

Start date = 1/9/2007 (Tuesday Jan 9 2007)
Days = 11

Roger = 1/26/2007 (Friday Jan 26 2007)
Martin = 1/25/2007 (Thursday Jan 25 2007)

I believe the correct result should be 1/29/2007 (Monday Jan 29 2007)

I think this is much more complicated than it appears on the surface.
After about an hour of tinkering I haven't come up with anything that
works *under all circumstances*.

JMB's suggestion works but listing all Fridays as holidays may not be
very desirable.

I haven't tried Arvi's udf.

Biff

"Roger Govier" wrote in message
...
Thank you, Martin.
Much appreciated and Happy New Year.

--
Regards

Roger Govier


"Martin Fishlock" wrote in
message
...
Roger,

That's a nice solution to the problem.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Roger Govier" wrote:

Hi

Provided you have ToolsAddinsAnalysis Toolpack selected, then you
could modify the Workday function.

=WORKDAY(Startdate,(Duration*5/4),holidays)
where holidays is a named range of holiday dates or a range of
cells
e.g. $C$1:$C$9 containing the holiday dates.

Multiplying your duration by 5/4 will account for a 4 day week.

--
Regards

Roger Govier


"tamarade" wrote in message
...
I am trying to create a formula that will result in a date. I
have a
start
date, a number of work days, however my dilemna is we only work 4
days. So
the formula would have to compute a completion date but exclude
Fri,
sat, &
sunday, any suggestions?