Workday Number

[#1]

I need to be able to determine in my load script the number associated with a workday where a workday is equal to a weekday excluding holidays.  I can load (externally) the holiday dates.  The real question is determining the workday number.  For example, if the 1st of the month falls on a Sunday, Monday would be my first workday so it should be the first workday, tuesday should be the 2nd workday, next monday would be the 6th workday and so on.  The goal is to be able to compare say the first 10 working days for every month.

Thanks,

Kevin

[swuehl]

Hi kkelly,

maybe you could use function networkdays(start:date, end_date{,holiday})

with start:date eq. MonthsStart(DATE), end_date eq. DATE and your imported list added.

Regards,

Stefan