Forum

Hi guys, Many thanks for all the replies, I went with Sunny's formula suggestions and that works. Appreciate all the help! Alan

Hi Frans, Thanks for the reply, the formula you suggested does work but on the sheet instead of displaying the #value error its displaying the word...

Hi Anders, Many thanks, I will give it a shot. Alan

Hi Mynda, Appreciate your advice, the bands are variable unfortunately so I will need to add the dates as you suggest - good to know that is the so...

Steve/Anders, Thank you both very much. Steve for some reason I was not able to get your formula to work but that could just be me! Anders, you...

Thanks Anders, I apologize for my request being a bit confusing, I guess I was hoping there might be an "easier" way to get the effect I am after w...

Hi there, I did say I would post again if I was struggling and I am 🙂 In the attached file you will see that I am trying to generate a gantt ...

SunnyKow/Anders, Many thanks for the help - that's a good start for me. I am going to try an incorporate some "If's" into the formula. Will let y...

Hi Velouria, Sorry about that - I changed the formula replacing the #REF errors with the cell references and it worked! Sample attached, many than...

Hi Velouria, Many thanks for helping me out here. I added your formula but have done something wrong I guess as I can't get it working, without th...