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 ToWeek28-07-2024  00:00 (Sunday)03-08-2024  23:59 (Saturday)Week 14-08-2024  00:00 (Sunday)10-08-2024  23:59 (Saturday)Week 211-08-2024  00:00 (Sunday)17-08-2024  23:59 (Saturday)Week 3……Week X (Continue till 2025)

​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 ToWeek28-07-2024  00:00 (Sunday)03-08-2024  23:59 (Saturday)Week 14-08-2024  00:00 (Sunday)10-08-2024  23:59 (Saturday)Week 211-08-2024  00:00 (Sunday)17-08-2024  23:59 (Saturday)Week 3……Week X (Continue till 2025)   Read More

​