Working Days per Month

[#1]

I am trying to build out a table that has either a calculated dimension or expression that will give me the number of working days (Business Days) in the proper month

For Example I am trying to complete the following table in QV

Year	Month	=(NetWorkingDays)
2012	Jan
2012	Feb
2012	Mar
2012	Apr
2012	May
2012	Jun
2012	Jul
2012	Aug
2012	Sep

Any help would be aapreciated

Thanks

Tim

[swuehl · Accepted solution]

If you have a Date field connected to your Month and Year, you could use

=networkdays( min(Date), max(Date) )

edit:

I assume here that you got a value for each Date in the calendar. If not, try

=networkdays( monthstart(makedate(Year, Month)), monthend(makedate(Year, Month)) )