Calc number of specific work days in month/year

[alanf]

I am trying to calculate the number of specific work days for a given month based on scheduled days off in a week for employees.

Input: normal days off (tuesdays and wednesdays)

Month: February

Year: 2008

Result: Number of work days in month for employee

Any help appreciated...

[comment]

Either one of these should get you started:

http://www.fmforums.com/forum/showpost.php?post/156042/

http://www.briandunning.com/cf/452

[alanf]

Thanks for the pointers to solve my problem!

I ended up using the WeekDaysInRange ( startDate ; endDate ; weekDays ) function as...

ValueCount(WeekDaysInRange ( startDate ; endDate ; weekDays )) to return the number of days.

Thanks again!

Alan