Results 1 to 7 of 7

Thread: DATE - Contract values for 2015

  1. #1
    Seeker Endi's Avatar
    Join Date
    Oct 2015
    Posts
    8
    Articles
    0
    Excel Version
    2013

    Question DATE - Contract values for 2015



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I have the following issue.

    I need to calculate the value of contracts for 2015.

    I have a similar table as the one further down, is there a possibility to calculate the value only for the contracts that are "live" in 2015?

    How do you calculate the annual contract values?


    Contract name Start date End date Value of Contract
    Contract A 02-07-10 02-07-16 1000
    Contract B 01-03-15 31-08-19 2000
    Contract C 12-12-14 05-07-15 2000
    Contract D 10-05-10 05-06-14 400
    Contract E 01-09-12 31-12-12 600


















    Does it make any sense?

    I do apologize, English is my second language.

    Greetings

  2. #2
    By live, do you mean contracts with end date >= today. (F2)


    If you mean where end date is >= Y2015 then (F3)
    Attached Files Attached Files
    Last edited by garfield101; 2015-10-23 at 11:50 AM.

  3. #3
    Seeker Endi's Avatar
    Join Date
    Oct 2015
    Posts
    8
    Articles
    0
    Excel Version
    2013
    Thank you garfield101 for your answer.

    I define "live: as contracts that have an active period in 2015, if there is a contract starting from Sep-2014 until Sep-2015 (the active period is 9 months in 2015).

    What you have written down is half right, but what is the contracts value of contract A in 2015 (and only in 2015)?

    I have been searching and boiling my head with this for 2 days and I cannot find any solution.

    Am I not seeing the forest because of the trees or am I dreaming of an impossible forest?

    Good day.

  4. #4
    So if start date is 1/1/2014 and end date 31/12/2015 and value 1000, then you want 500
    and is start date is 1/1/2013 amd end date 31/12/2016 and value 1000, then you want 250
    Is that right?

  5. #5
    Seeker Endi's Avatar
    Join Date
    Oct 2015
    Posts
    8
    Articles
    0
    Excel Version
    2013
    Indeed.

    The solution I have found was to add 7 columns in order to process every step, I am wondering if there is another (cleaner, easier, nicer) way.

  6. #6
    Is this what you are looking for
    Attached Files Attached Files

  7. #7
    Seeker Endi's Avatar
    Join Date
    Oct 2015
    Posts
    8
    Articles
    0
    Excel Version
    2013
    Thank you garfield101,

    That is what I am looking for, your result is different from mine because you use days and I was using months but basically is the same.

    Thank you for your support, can we endorse each other?

    Have a great day.

Tags for this Thread

Posting Permissions

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