How to increase each every date +1 until +4

[acaryasin01]

Hi,

I have a table like below

Date
9-5-2022
16-5-2022
23-5-2022
30-5-2022
6-6-2022
13-6-2022
20-6-2022
27-6-2022
4-7-2022
11-7-2022
18-7-2022

But I want to increase each every date +1 until +4 like below desired column

Date	Desired Date
9-5-2022	9-5-2022
	10-5-2022
	11-5-2022
	12-5-2022
	13-5-2022
16-5-2022	16-5-2022
	17-5-2022
	18-5-2022
	19-5-2022
	20-5-2022
23-5-2022	23-5-2022
	24-5-2022
	25-5-2022
	26-5-2022
	27-5-2022

Thanks in advance...

[Matthew · Accepted solution]

here's what i would do

use a summarise tool to get a list of all the unique dates

use a generate rows tool to get each of those dates plus 1, 2,3 and ,4

then join those back onto the original dataset

attached is an example

[acaryasin01]

Much appreciate @Matthew 

It's working 👍🙏😊