+ Reply to Thread
Results 1 to 5 of 5

Need To Know The End Of Contract

  1. #1
    Registered User
    Join Date
    04-26-2016
    Location
    Canada
    MS-Off Ver
    10
    Posts
    3

    Need To Know The End Of Contract

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need To Know The End Of Contract

    Welcome to the board.

    A
    B
    C
    D
    E
    F
    1
    Employee
    Hire
    Years
    Status
    End
    2
    John
    2/7/2002
    2
    2/7/2017
    E2: =EDATE(B2, (DATEDIF(B2, TODAY(), "y") + C2)*12)
    3
    Sergio
    1/3/2015
    2
    1/3/2018
    4
    Clive
    1/1/2016
    2
    1/1/2018
    5
    Michael
    10/5/2010
    2
    10/5/2017
    6
    Sara
    1/9/2001
    2
    1/9/2017
    7
    Joly
    1/9/1990
    2
    1/9/2017
    8
    Onno
    1/3/2014
    2
    1/3/2018


    If that's not the answer, explain why not, and what the correct answer is.
    Last edited by shg; 04-26-2016 at 03:25 PM.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    04-26-2016
    Location
    Canada
    MS-Off Ver
    10
    Posts
    3

    Re: Need To Know The End Of Contract

    Thank you so much ..

    that's what I am looking for.

    best wishes,
    Abraham

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Need To Know The End Of Contract

    You're welcome.

  5. #5
    Registered User
    Join Date
    04-26-2016
    Location
    Canada
    MS-Off Ver
    10
    Posts
    3

    Re: Need To Know The End Of Contract

    Dears,

    Another thing, if I want to show the end of renewed contract as per today like the attached table.

    is there any formula can do that ?

    Thanks,
    Abraham
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Lifetime value of a contract
    By ammartino44 in forum Excel General
    Replies: 8
    Last Post: 05-15-2014, 06:20 PM
  2. how to sum all the contract until end of the contract period
    By neskafeice in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2012, 07:37 AM
  3. IF Statements - Apportion Contract Value
    By belge in forum Excel General
    Replies: 4
    Last Post: 09-15-2010, 04:02 PM
  4. monthly split of contract value
    By nazimscr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-13-2010, 03:41 PM
  5. Service Contract Schedule
    By gracust in forum Excel General
    Replies: 4
    Last Post: 07-13-2010, 04:56 PM
  6. Calculating Contract Value
    By petersen313 in forum Excel General
    Replies: 1
    Last Post: 09-25-2007, 05:06 PM
  7. Lookup:Staff,Contract
    By nussbaum in forum Excel General
    Replies: 1
    Last Post: 02-24-2005, 08:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1