Max duration between dates

[ksk278074]

HI all,

I am having data like below.

Startdate,closedate,location

1/1/2021,2/1/2021,ind

4/1/2021,10/1/2021,ind

5/1/2021,7/1/2021,IK

8/1/2021,15/1/2021,uk

Based on the above data i want to calculate the maximum date difference between the dates based on location.

Could you please help me on the same. 

[ksk278074]

Any suggestions ?

[ksk278074]

Can some suggest me how to do that?