Hi Mo

Glad it worked for you and thanks for posting back to let us all know.

--
Regards

Roger Govier


"Mo" wrote in message
...
Yahoo, it works!!! Thank you so much! You have just helped me save so
much
time for so many people. And thank you for the 3rd perameter
(holidays). This
is the first time I've written into a discussion group & it's been a
great
experience. Thanks everyone for your help.
Mo

"Roger Govier" wrote:

Sorry Mo

I should have said you need the Analysis Toolpak loaded.
ToolsAddinscheck Analysis Toollpak

--
Regards

Roger Govier


"Mo" wrote in message
...
Thanks, Roger, I think you got to the heart of my issue. It seems
like
that
should work...I just tried it and I'm getting the #NAME? message.
Could I be
doing something inherently wrong that's having a downstream effect,
like date
format or something basic?

"Roger Govier" wrote:

Hi Mo

You need Workday() not Networkdays
=WORKDAY(A1,2) with 13 Oct 2006 in A1 returns 17 Oct 2006

--
Regards

Roger Govier


"Mo" wrote in message
...
I had looked at that function, but it seemed to me that it was
intended
to
calculate the number of work days between two dates and I'm
looking
for a
formula/function that will return an actual date. For example,
10/13/06 + 2
business days = 10/17/06. It sounds like simple math, but my
objective
is to
create a spreadsheet where I can plug in a couple of key dates
and
the
rest
of the dates will generate based on formulas & functions. Know
of
anything
that could work for that?

"Dave F" wrote:

Look at the function NETWORKDAYS
--
Brevity is the soul of wit.


"Mo" wrote:

I'm trying to build schedules in Excel with anywhere between
10
and
30
scheduled tasks within the timeline of a few months. The
formulas I
need to
use seem like they would be pretty basic, but I realize I
need
some
task
dates based on calendar days and some on business days. For
example, I need
to allow a calendar week for people to provide comments, but
then
need to
print the document 2 business days later. So how do I
distinguish
between
counting calendar days and counting only business days? I've
searched the
help options in Excel and nothing I've found seems to speak
to
this
particular issue. I'm also pretty new to working in Excel, so
there
might be
an obvious solution out there that I just don't know about.
Thanks!
Maureen