Calculating how many days in a year revenue to recognise between different contract dates

[beanie3105]

Hello

Hopefully this is an easy one - I am trying to calculate how much revenue we should have recognised for different contracts in 2021 - however each contract has different start / end dates. Some started in 2020, some started part way through 2021, finished part way through, go on to 2022. Is there an easy way to find out how many dates relate to a specific year between contract dates?

 

[BSALV]

Map1
	A	B	C	D	E
1				1/01/2022	31/12/2022
2				start	end
3	contract A	1/05/2020	1/05/2022	121
4	contract A	28/02/2022	1/05/2023	307
5	contract C	31/12/2021	1/01/2023	365
Blad2

Cell Formulas
Range	Formula
D3:D5	D3	=IF(COUNT(B3:C3)=2,MAX(0,MIN($E$1,C3)+1-MAX($D$1,B3)),"-")

 

[beanie3105]

=IF(COUNT(B3:C3)=2,MAX(0,MIN($E$1,C3)+1-MAX($D$1,B3)),"-")

This is amazing and works perfectly, thank you so much