Posts by angelic1

Re: Calculate days between 2 dates

[TABLE="class: cms_table, width: 596"]

[tr]

[TD="colspan: 5"]Fiscal year - 1st April'16 to 31st March'17[/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]

[/TABLE]

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

http://www.excelforum.com/exce…-2-dates.html#post4501786

http://www.excelkey.com/forum/…ic.php?f=2&p=25344#p25344

http://www.mrexcel.com/forum/e…days-between-2-dates.html

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