My assumption was that the start date is inclusive

That's not how WORKDAY works.

Biff

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

My assumption was that the start date is inclusive, you don't start the
day
after the start date. So starting on Tues 9th would finish on the Fri 25th
if
the time was 11 days.


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"T. Valko" wrote:

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?