View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Networkdays Function

On Mar 19, 3:12*pm, Gord Dibben <gorddibbATshawDOTca wrote:
"NET" is a valid term as in "net profits" so why should it bother you
when Excel uses it?

"gross workdays" function is NETWORKDAYS function with no
designated holidays range.


My point exactly: I don't believe there is a single business person
who thinks of, much less refers to, "net" work days, meaning all
("gross") work days less holidays.

Moreover, regarding your analogy, I would never create a function
called NETPROFIT() that actually returns gross profit if arguments
change. It violates the Principle of Least Surprise.

Arguably, simply WORKDAYS is a more resonable name -- kinda like
DAYS360. I suspect that was avoided because of its similarity to
WORKDAY. (Refer to "Psychology of Computer Programming".)

But we are taking my comments too seriously. I was just pointing out
that I have to take a double-take every time someone asks about
NETWORKDAYS in these forums because my brain is wired (no pun
intended) to see that as "network days", not "net work days".
(Ignoring the nonsensical notion of "net" work days, in the first
place.)

If your brain is wired differently, more power to you.