Forum Discussion
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 | Week |
| 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) |
See the attached workbook.
