Forum Discussion
anwarsafian
Jun 08, 2024Copper Contributor
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) |