Date minus work days

H

HK

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
 
H

HK

HK said:
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.
 
D

Dave Peterson

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.
 
R

Ron Rosenfeld

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
 
H

HK

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
 
F

Fred Smith

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 said:
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
 
H

HK

Fred Smith said:
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
 
J

John

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

HK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top