Good afternoon!

I am helping a friend build up a gnatt chart but am struggling.

As it is supposed to run for several years, to limit the use of columns, I am using one cell per week and try using "REPT" with blanks (" ") and bars ("¦") to show the number of days worked. The blanks are there to align the bars either to the right or to the left depending on whether the first part of the week is worked, or the second part only.

I use networkdays which allow for public holidays. However, with the long formula I came up with, I have not managed to show the public holidays themselves as blanks as the formula was getting so long.

I was wondering whether by some clever trick the formula could be reduced dramatically AND allow the public holidays to show up!

I am asking much, I know.

I find the date formulas extremely hard to handle most probably because I do not use them often enough.

I would appreciate any help.Thanks!

Danèle

PS I am adding a short version of the gnatt chart with the bars shown as little rectangels to make it easier to see the number of days.

example-gnatt.xls
Can it be a UDF (User Defined Function using VBA)?