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]

[TABLE="width: 596"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 5"]


[/TD]
[TD="colspan: 5"] Financial Year [/TD]
[/TR]
[TR]
[TD]Activation date[/TD]
[TD] [/TD]
[TD]Expiry date [/TD]
[TD] [/TD]
[TD]Total No Of Days [/TD]
[TD]2015-16[/TD]
[TD] [/TD]
[TD]f.y.2016-17[/TD]
[TD] [/TD]
[TD]f.y.2017-18[/TD]
[/TR]
[TR]
[TD]1-Apr-2015[/TD]
[TD] [/TD]
[TD]30-Apr-2015[/TD]
[TD] [/TD]
[TD] 30[/TD]
[TD]30 [/TD]
[TD] [/TD]
[TD]0 [/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]21-Mar-2016[/TD]
[TD] [/TD]
[TD]9-Apr-2016[/TD]
[TD] [/TD]
[TD] 20[/TD]
[TD]11[/TD]
[TD] [/TD]
[TD]9[/TD]
[TD] [/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1-Mar-2016[/TD]
[TD] [/TD]
[TD]20-Mar-2018[/TD]
[TD] [/TD]
[TD] 750[/TD]
[TD]31[/TD]
[TD] [/TD]
[TD]365[/TD]
[TD] [/TD]
[TD]354[/TD]
[/TR]
</tbody>[/TABLE]

 

[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))