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