I need an excel spreadsheet with a formula I can place in other worksheets that will calculate the number of days between two dates in terms of how many days were in a leap year and how many days were not. Example between 11/24/2011 and 10/1/2013 there are 366 days in a leap year and 311 in a non-leap year in order to determine total interest between those dates where the rate is computed on a daily rate based on a 365 year in a normal year and a 366 year in a leap year. As an example on a balance of 230,120.71 a straight line computation shows there is 677 days so on a 5.375% at 5.375% would be $22,941.93 but in what I need a spreadsheet to determine is that because 311 of the days were based on a 365 day year and 366 of them were based on a 366 day year the interest calculates at $22,908.04 so you can see why I need the spreadsheet that calculates the exact number
Hi,
I am good at Excel and formulas. Looking forward to work on this project. I would like to discuss further in the chat. Can u plz provide me the excel sheet.