Calculate days between 2 dates

[Angelic1]

I would like to calculate number of days between 2 dates which consists of 3 or 4 years together.... I would like to know days between each financial year eg. 1-March-16 to 5-April-17


financial year -------------days
April 2015- March 2016--- 31 days
Apr 16 to mar 17-----------365 days
Apr 17 to mar 18--------- 5 days


please help me with the nested if date formula.... I m finding it difficult to crack..


thank you

 

[AlanY]

try this

Excel 2012
	A	B	C	D	E	F
1				Financial Year
2	Activation date	Expiry date	Total No Of Days	2015-16	2016-17	2017-18
3	01-Apr-15	30-Apr-15	30	30	0	0
4	21-Mar-16	09-Apr-16	20	11	9	0
5	01-Mar-16	20-Mar-18	750	31	365	354
Sheet1

Cell Formulas
Range	Formula
D3	=IF($A3<=DATE(LEFT(D$2,4)+1,3,31),MAX(MIN(DATE(LEFT(D$2,4)+1,3,31)-$A3,$B3-DATE(LEFT(D$2,4),4,1),DATE(LEFT(D$2,4)+1,3,31)-DATE(LEFT(D$2,4),4,1))+1,0),0)

 

[Angelic1]

Thank you so much!!! It really means alot...... U r genius. U solved my query thank you again

 

[AlanY]

You're welcome