Weekend rota Planning (generate values based on criteria/date/shift pattern)

Please anyone can help ? Can some help with formula to be able to generate time and green color in certain cells automatically ones the date is changed based on entered values or based on 4on 4of shift pattern, more explanation included on attached workbook.