NETWORKDAYS, Holiday problem

  • Thread starter Thread starter CLR
  • Start date Start date
C

CLR

Hi All..........

Win98SE, XL2k,
Trying to do a NETWORKDAYS formula and in checking it out I notice that
whenever I put random days into my Holiday list, all works fine, but if I
enter recognized holidays, like July 4, or Dec 25, the formula completely
ignores them as tho they were not even there........this just won't
do..........what have I done wrong?
"from", "to", and "Offdays" are range names..........

=NETWORKDAYS(from,to,Offdays)

Vaya con Dios,
Chuck, CABGx3
 
Hi CLR!

Could it be because 4th July and 25th December are Sunday and Saturday
this year? They get double ignored on the grounds that they are at
weekends and in your holiday list.

But watch out for potential of substitute holidays where the public
holiday fall on a weekend.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
<BLUSH>.......
Thanks Norman, that's probably it, and thanks for the heads-up about other
holidays as well.

Vaya con Dios,
Chuck, CABGx3
 
Hi CLR!

No problem!

In passing, do you know if US Holidays that fall on a weekend get
substituted by another day and if so, what day. In Australia it tends
to be the following Monday.

If there's no substitution, you're going to be short changed this
year!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Norman.........

I don't know what the official "rules" are here. I think the monday thing
is also the norm, but I think each Company might come up with a list of
their own holidays and substitutions they choose to support. So, each list
wold be custom.

What my project here is to create a Department work-loading program, so the
Manager can decern from his list of job entries, using Estimated times, Dept
numbers, Dept staffing, etc,, just how much backlog he has for each
department. It just occured to me that I must also deal with vacations, and
"sick" leave........I suppose I could make a separate "holiday" list for
vacations but one cannot anticipate "sick" days.............maybe just enter
as a constant percent?(after all, the Estimated Times are just
estimates).....................any suggestions?

Vaya con Dios,
Chuck, CABGx3
 
Hi CLR!

Here we have statutory public holiday substitutes done on a State by
State basis.

On personal holidays I think that you might make guestimates of time
taken during the prime holiday periods such as August and the
Christmas - New Year period. For short term purposes you might even
have some accurate data with holiday schedules used within the
departments.

For sick leave? A constant percentage looks the way to go. You might
even have some company records to get that percentage

But, as you say, these are only estimates and anything that you do is
not likely to be correct but will be more accurate than ignoring the
issues.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks again Norman...............
All good food for thought..........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top