Grouping formula

Hi expert   I would like to create formula as shown in below table. If I only use IF and AND formula, it will be long and complex formula. How can I simplified this formula?   From  To Wee...