gantt chart booking system - help please

[LongJohn]

I have developed a booking system for short term hire items with a gantt type display showing the days that an individual booking covers. I am unsure of how to move to the next stage which would show more than one booking on the gannt chart which normally shows one month ahead. For the current booking I use a let statement to load a repeating field. Conditional formatting provides the colour bars for the gannt chart.

 

Let([

current_date = Extend( gantt_Start_Book ) + Get ( CalculationRepetitionNumber )

];

If(current_date < Extend( Book_From ) + 1 ; "Av" ; 

If( current_date  ≥  Extend( Book_From ) + 1 and current_date  ≤  Extend( Book_To ) + 1 ; Left( Extend( Book_Category ) ; 2 )  ;

If(current_date > Extend( Book_To ) + 1 ; "Av" ; ""

) ) )

)