Dears,
I hope you are doing well,
I need a formula to get the end of contract date for each employee as shown in the attached file.
Keep in mind that, the Start Date column is renewed automatically after finishing two years. Meaning, if my Start Date was in 01/01/2002 and my contract is already renewed for each two years that means my end of contract date will be 01/01/2016 as per today.
I need a formula to calculate that because I need to calculate the whole employees in my company.
Can anyone help me out here,
Thanks
Abraham.
Bookmarks