Adding consecutive rows based on consecutive dates

[DanielCarro]

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

[Raj · Accepted solution]

@DanielCarro 
find the workflow attached
mark done if solved.

[ChrisTX]

I didn't get the same result as your expected output.  Not sure I understood the assignment.

Hopefully this will point you in the right direction.  The primary tool is the Multi-Row Formula tool.

 

Chris

[DanielCarro]

Hi @Raj ,

Your solution worked. Thank you so much.