Grouping formula

Copper Contributor

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 ToWeek
28-07-2024  00:00 (Sunday)03-08-2024  23:59 (Saturday)Week 1
4-08-2024  00:00 (Sunday)10-08-2024  23:59 (Saturday)Week 2
11-08-2024  00:00 (Sunday)17-08-2024  23:59 (Saturday)Week 3
Week X (Continue till 2025)

 

1 Reply

@anwarsafian 

See the attached workbook.