Calculate workdays in a month
I'm looking to find a way to calculate the workdays in a given month, so just Monday to Friday.
A lot of calcs I've seen rely on the user entering start and end dates.
I'm hoping that FM has an intelligent calendar and is able to help in returning that June 2014 has 20 work days, for example. Ideally this would all be done automatically on the table with each record representing a separate month. The use case is that a user then enters work hours directly into the portal for that table and, hey presto, we have their monthly hours with 12 portal rows.
Any help appreciated, thanks