Googlel Sheets: repeat first and last week based on image insert in cell

[adirusf]

Hi to all,
I'm facing a problem... I want to get the first and last week in which different control tests take place. I tried to use the index and match function, which helped me in part to obtain the desired result, but if the control test takes place over several periods of time with interruptions, the result is not the desired one.I mention that I will only insert images in the cell (exactly as in the attached file) and I will not use numbers or letters . Many thanks
generate first and last week.xlsx

[AliGW]

As you state in the workbook that this is for Google Sheets, I have moved the thread.

[janmorris]

If you want to do any data manipulation using images as the control, then you will need to use Apps Scripts.

[adirusf]

I was initially thinking of using images, but I will replace those images with numbers or letters. I am not familiar with app scrips . This is how an annual planning looks like for each test, periods that may differ depending on the class. Control problems sometimes take place in 2 groups (for example Handball/Basketball from the attached picture, sometimes in a single group. calendar.jpg