In my Help, it states that Days is "the number of non-weekend and
non-holiday days before or after the start_date". Does yours not say the
same thing?

The other thing I'm curious about is why is it easier to post a question to
the discussion board, than simply try it out to see what happens?

Regards,
Fred

"HK" wrote in message
...
I looked in Help before I wrote.

Second argument in WORKDAY is "days"
But how do I find "days" when what I have is workdays.

In NETWORKDAYS first argument is "start_date". How do I find "start_date"
when what I have is "end_date" and number of workdays.

Hans



"Dave Peterson" skrev i meddelelsen
...
Look in excel's help for =workday()

If you're using xl2003 or earlier, you'll need to have the analysis
toolpak
loaded. Excel's help explains how to do that, too.

You may want to look at =networkdays(), too.

HK wrote:

In A1 i have: 29-May-2010
In A2: 20 (workdays)
In A3: 13-May-2010 (holiday)
In A4: 24-May-2010 (holiday)

I need to find the date of A1 minus number of workdays in A2,
considering
the holidays in A3:A4.

Hans Knudsen

--

Dave Peterson