Networkdays

[#1]

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

[swuehl · Accepted solution]

Not sure what's causing  your problem.

I have attached a simple example of how it should work.

Regards,

Stefan

[#3]

Thank you so much.

i was looking too long at complicated formulas that I've found here and there for this.

Did not realise it was that simple. thank you so much for your help.

Much apreciated !!