Biff,

The NetWorkDays function, which you are attempting to
mimic, does not have either of these limitations.

Are you sure about that?

The limitations you're refering to are not related to the NetWorkDays function
per se.
They are related to the capacity to specify (via formulas or hard code) REAL
holidays date for a given country, (depending on laws, etc) and to subsequently
put those REAL dates in your holidays range.

There's a difference between an incorrect range of holidays and a flawed
formula.

I do see your point and it's well taken but this is one of
those situations that you cannot completely automate, IMO.

So, to take your example, a formula (included in your holidays range) could
account for Christmas Eve and Christmas Day off occuring on weekend for that
perticular year and produce the proper REAL holiday dates in that year (either
before or after weekend).

Build the proper REAL holidays dates (depending on your country's laws,
traditions) either by hard input or formula, and the NETWORKDAYS() will work
appropriately.

Regards,

Daniel M.