I need help writing a complex formula

Dear people, I have just started a new postion which i have to expert in Excel. I have some data regarding the trainings dates and i have to fill them in a new excel form in order to upload them to ...