2 Replies Latest reply: Aug 23, 2011 4:39 AM by michielsguy RSS

    Networkdays

      Hi all,

       

      I would like to try out some stuff around capacity planning. But I was looking for a way to create a table thet I can use so I can see at once for the next 12 months and for each month how many working days there are.

       

      Jan.        21

      febr.        18

      March      20

      ....

       

      In this way I can use the numbers to calculate the capcity in hours on each production line.

       

      I've us the networkdays functions..; but it seems it only works when one month is selected. When i select mutiple months.. it just adds up.

       

      Can someone give me som insight please

       

      thank you in advance