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?




















Does it make any sense?

I do apologize, English is my second language.

Greetings

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


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

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.

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?

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.

Is this what you are looking for

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.