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
http://www.ozgrid.com/forum/showthre...270#post779270
http://http://www.excelkey.com/forum/viewtopic.php?f=2&t=8638&p=25346#p25346
http://www.mrexcel.com/forum/excel-q...n-2-dates.html
Bookmarks