number of days by year

[SvenB]

Hello guys. I am currently facing an issue related to how to allocate the difference between some dates into specific years.
Let's assume the period below.

start_date	end_date
03-03-2015	5-06-2017

<tbody>
</tbody>

Given this period, I would like to compute the days corresponding to each year: 2015, 2016 and 2017.

2015	2016	2017

<tbody>
</tbody>

It is possible to achieve this by not doing a nested if?

Thank you.

 

[Luigi802]

Hello guys. I am currently facing an issue related to how to allocate the difference between some dates into specific years.
Let's assume the period below.

start_date	end_date
03-03-2015	5-06-2017

<tbody>
</tbody>

Given this period, I would like to compute the days corresponding to each year: 2015, 2016 and 2017.

2015	2016	2017

<tbody>
</tbody>

It is possible to achieve this by not doing a nested if?

Thank you.

Not sure what exactly you're asking, are you trying to count the days from 03-03-2015 to 05-06-2017?

 

[shg]

	A​	B​	C​	D​	E​	F​	G​	H​
1​	Start​	End​	2014​	2015​	2016​	2017​	2018​
2​	2015-0303​	2017-0506​	0​	304​	366​	125​	0​	C2: =MAX(0, MIN($B2, DATE(C$1, 12, 32)) - MAX($A2, DATE(C$1, 1, 1)))

 

[SvenB]

Thank you. It is working like a charm.

 

[shg]

You're welcome.