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