AnsweredAssumed Answered

Calculate workdays in a month

Question asked by Stu412 on May 14, 2015
Latest reply on May 18, 2015 by philmodjunk


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