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

"HK" skrev i meddelelsen
...
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

Did I express myself clearly?
I meant counting backwards 20 workdays from May 29th 2010, considering the
stated holidays. The result should be 29-April-2010.

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

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

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

"Fred Smith" skrev i meddelelsen
...
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



Even if English is my second language I notice a good deal of sarcasm here.
Am I right? If yes, I simply do not understand. I have read help and I have
tried out. Have you in any detail read what I wrote?

Let's say I have:
=NETWORKDAYS(A1;A2;H1:H3)
where A1: 28-April-2010
and A2: 29-May-2010
and H1:H3 I have 3 holidays between 28 April and 29 May.
Here the NETWORKDAYS function returns 20.

What I need is a formula where I have the date 29 May and I want returned 28
April based on the assumption of 20 work days back from 29 May.

Hans Knudsen

Hi HK
Ron Rosenfeld has given you your answer =WORKDAY(A1,-A2,A3:A4)
Is it not working?
HTH
John
"HK" wrote in message ...


"Fred Smith" skrev i meddelelsen
...
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



Even if English is my second language I notice a good deal of sarcasm here.
Am I right? If yes, I simply do not understand. I have read help and I have
tried out. Have you in any detail read what I wrote?

Let's say I have:
=NETWORKDAYS(A1;A2;H1:H3)
where A1: 28-April-2010
and A2: 29-May-2010
and H1:H3 I have 3 holidays between 28 April and 29 May.
Here the NETWORKDAYS function returns 20.

What I need is a formula where I have the date 29 May and I want returned 28
April based on the assumption of 20 work days back from 29 May.

Hans Knudsen

My hasty response was due to the fact that I felt the accusation of misusing
the discussion board was unjustified. It never was my intention to misuse
the board, neither in this thread or at any time. After having slept some
hours I realize that all who answered were right and I was wrong.
My unreserved apology to all.

Hans Knudsen

On Mon, 8 Feb 2010 17:16:47 +0100, "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

Look in HELP for instructions on how to use the WORKDAY function.

Your formula will look something like (untested):

=workday(a1,-a2,a3:a4)

If you get a #NAME error, the instructions for correcting that will be in HELP
for the WORKDAY function.
--ron