# Thread: DATE - Contract values for 2015

1. ## DATE - Contract values for 2015

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. By live, do you mean contracts with end date >= today. (F2)

If you mean where end date is >= Y2015 then (F3)

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. 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. 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. Is this what you are looking for

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