Hi guys,
I have a small situation and any advice will be appreciated.
In the output, I need to add the days as per the consecutive dates. In DATE2 DAY WEEKDATE, this column has taken care of any weekend dates.
I couldn't try the summarize too as I can't group these due to having different dates.
As well, I tried the multi-row formula and not working either.
input:
| ID | TYPE | DATE | DATE2 DAY WEEKDATE | DAYS | |
| 3865 | Holidays | 02/07/2024 | 03/07/2024 | 0.5 | |
| 3865 | Holidays | 03/07/2024 | 04/07/2024 | 1 | |
| 3865 | Holidays | 04/07/2024 | 05/07/2024 | 1 | |
| 3865 | Holidays | 05/07/2024 | 08/07/2024 | 1 | |
| 3865 | Holidays | 08/07/2024 | 09/07/2024 | 1 | |
| 3865 | Holidays | 09/07/2024 | 10/07/2024 | 1 | |
| 3865 | Holidays | 10/07/2024 | 11/07/2024 | 1 | |
| 3865 | Holidays | 30/07/2024 | 31/07/2024 | 1 | |
| 3929 | Holidays | 04/07/2024 | 05/07/2024 | 1 | |
| 3929 | Holidays | 05/07/2024 | 08/07/2024 | 1 | |
| 3929 | Holidays | 12/07/2024 | 15/07/2024 | 1 | |
| 3929 | Holidays | 19/07/2024 | 22/07/2024 | 1 | |
Output:
| ID | TYPE | DATE | DATE2 DAY WEEKDATE | DAYS | |
| 3865 | Holidays | 02/07/2024 | 03/07/2024 | 6.5 | |
| 3865 | Holidays | 30/07/2024 | 31/07/2024 | 1 | |
| 3929 | Holidays | 04/07/2024 | 05/07/2024 | 2 | |
| 3929 | Holidays | 19/07/2024 | 22/07/2024 | 1 | |
| | | | | | |
| | | | | | |
| | | | | | |
Kind Regards,
Dan
