hi
glad you sorted it out ;-)

--
Regards
Frank Kabel
Frankfurt, Germany

"Chris Maximus" <Chris schrieb im
Newsbeitrag ...
Greetings Frankfurt!

Frank I kept trying this and it wouldn't work. But then as I was
sending you
another response, I noticed the "Note: You have to install the
toolpak for
this function"

Dooh!

So I installed the Analysis Toolpak, and everything is working now.

Thank you very much!!!

"Frank Kabel" wrote:

Hi
=WORKDAY(A1,A2)

--
Regards
Frank Kabel
Frankfurt, Germany

"Chris maximus" <Chris schrieb
im
Newsbeitrag
...
I guess I should have explained mo Cell a1 has date
(12/01/04),
cell a2
has number of work days (42), I need to add the two and get end
date,
where
42 will be read as workdays, and would return a date of 2/03/05
instead of
1/12/05.

"Frank Kabel" wrote:

Hi
use WORKDAY for this

Note: You have to install the Analysis toolpak Addin for this
function

--
Regards
Frank Kabel
Frankfurt, Germany

"Chris Maximus" <Chris
schrieb
im
Newsbeitrag
...
I want to have a spreadsheet where I add a workday number to
a
date
and get
the end date, like MS Project. What formula would I use to
get
the
result to
show the duration as wrok days?