4 Replies Latest reply: Sep 25, 2018 4:27 AM by David Štorek RSS

    Working days and filter

    Del Booth

      Hi.

       

      I am trying to use the networkdays function to get the number of days in a month.  I have a filter called SchMonth that lists the months as Jan, Feb etc.  I have tried using the expression below to get the number of days when a month is selected in the filter SchMonth but it does not give the number of days for the month ie selecting Feb in SchMonth does not give the correct number of working days ie 20

       

      =NetWorkDays(MonthStart(SchMonth),MonthEnd(SchMonth))

       

      Thanks