Create End Date per ID and also find Average days between Start and End Dates per ID

[qlikwiz123]

Hi, I have my data as shown below.

ID	Date
111	6/1/2023
111	6/2/2023
111	6/3/2023
123	6/3/2023
156	6/11/2023
156	6/12/2023
846	5/14/2023
846	5/14/2023
846	5/15/2023
846	5/16/2023
846	5/17/2023

I need to create an End Date and also find average number of days between Date and End Date per ID

ID	Date	End Date	Average Days
111	6/1/2023	6/3/2023
123	6/3/2023	6/3/2023
156	6/11/2023	6/12/2023
846	5/14/2023	5/17/2023

[Or]

Looks like a direct duplicate of https://community.qlik.com/t5/New-to-Qlik-Sense/Create-End-Date-per-ID-and-also-find-Average-days-be...