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

 

[Muhammad_Usman]

You can just minus oldest to newest date. and format it as general!

 

[Angelic1]

[FONT=&quot]Thank you for replying, but this does not solve my purpose. I wanted to use IF & date function together in three different columns as below[/FONT]

[FONT=&quot]Activation date -21-Mar-2016 [/FONT]
[FONT=&quot]Expiration date - 9-Apr-2016[/FONT]
[FONT=&quot]total No Of Days - 20[/FONT]

[FONT=&quot]f.y.2015-16 - 11[/FONT]
[FONT=&quot]f.y.2016-17 - 9[/FONT]
[FONT=&quot]f.y.2017-18 - 0[/FONT]

 

[RoryA]

Cross posted:
http://www.ozgrid.com/forum/showthread.php?t=201453&p=779270

http://http://www.excelkey.com/forum/viewtopic.php?f=2&t=8638&p=25346

URGENT HELP PLEASE - calculate days between 2 dates

Our cross-posting rules are much the same as everyone else's - please abide by them in future. Thanks.

 

[Angelic1]

URGENT HELP PLEASE - calculate days between 2 dates

 

[Muhammad_Usman]

Explain your current data format and your expected result....

 

[Angelic1]

	Financial Year
Activation date		Expiry date		Total No Of Days	2015-16		f.y.2016-17		f.y.2017-18
1-Apr-2015		30-Apr-2015		30	30		0		0
21-Mar-2016		9-Apr-2016		20	11		9		0
1-Mar-2016		20-Mar-2018		750	31		365		354

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Muhammad_Usman]

Your Fiscal year ??

 

[Angelic1]

Sorry!, 1st April'16 to 31st March'17

 

[Angelic1]

Also, I'll like to add that i tried using the below formula for column 'Financial year 01-Apr-2015 to 31-Mar-2016', BUT I am not able to deal with rest 2 columns.

=IF(A1>DATE(2016,3,31),0,IF(B1< DATE(2016,4,1),C1,DATE(2016,3,31)-A1+1))