Year wise cumulative split of days

Dear Experts,

Thanks for your valuable support. I am looking to split the total days cumulative year wise looking into start days and end days. Year wise days should be cumulative. i.e. year 2013 days are 0, 2014 days are 207, 2015 days are 572 and so on till it check the end date. Beyond it should zero. Example file is attached for your reference.

Days Years - start from 01/04/ and end at 31/03
Start Date End Date Total Days 31-03-2012 31-03-2013 31-03-2014 31-03-2015 31-03-2016 31-03-2017 31-03-2018
06-09-2013 05-06-2016 1004 0.00 0.00 207.00 572.00 938 1303.00 0.00 0.00 0.00 0.00

Regards,

Something like this and dragged:

=IF(OR(D$4<$A$5,D$4>$B$5),0,IF(D$4>=$A$5,D$4-$A$5+1))

But in your data, the end date is 05-06-2016, so the number of days for 31-03-2017 should be 0, not 1303.

I agree with Paul that 1303 is wrong but thik the answer should be 1004

in d5
=IF(AND($A5<D$4,$B5>C$4),MIN(D$4,$B5)-$A5+1,0)

but I think it does the same thing

Hi PaulM100

Thanks for your prompt reply. Formula works except for end year 31.03.2017 since end date 05-06-2016 falls in 31.03.2017. It shows 0 days in year 31.03.20017 where cumulative days should be 1004.

Reagrds,

@Davsth,

Note the OP had total days as 1004 so your answers is correct: he was looking for the answers you supplied!!