Making two date from one date based on assumption

[sarfaraz_sheikh]

Dear ALL,

I have the following data and I needs to calculate Start_Date and End_Date from Update date.

Input:  

Update date	Talisma Name	Team Name	TL Name
31-Jan-16	Naresh   Medicala	The Achievers	Krunal Panchal
1-Feb-16	Naresh Medicala	Silver Hawks	Sumeet Chothani
22-Apr-16	Naresh Medicala	The Victorious	Hemant Mohapatra

Output:

Start_date    End_Date                           TalismaName     TL_Name

31-Jan-16      31-Jan-16                          Naresh               KrunalPunchal

1-Feb-16        21-Apr-16                          Naresh               SummetChothani

22-Apr-16       11-May-16(Today()-1)         Naresh               HemantMohapatra

The logic behind the calculation is Update_date should get consider as Start_Date but for End_Date should get populate on the basis of nextdate-1  of Update_date field as wrote in my output.

Can anybody tell me how i can build the logic for the Same dynamically.

Help / Suggestion would be much appreciated if any !!

gwassenaar‌ , hic‌  , jagan‌  PLease comment

Regards

Sarfaraz

[jonathandienst]

I can't open rar files from where I am currently working. Could you upload a zip?

[sarfaraz_sheikh]

I don't have winzip installed in my machine ....for your reference i am attaching XL file.

Thanks

Sarfaraz