Hi,
I'm making a spreadsheet that needs to figure out the yearly cost for a given rail car that is being leased. I have a column F that is the lease expiration date (i.e. 9/30/2013) and a column G that is the lease rate (i.e. $375). The next 7 columns (H-N) are labeled Year 1 Cost, Year 2 Cost, etc. My question is, how do I put a formula in those cells that will calculate the yearly cost based on the number of months that the lease will exist in that year? So for 9/30/2013 the column for year 1 cost would have to recognize that there would only be 9 months in that year. Then the column for year 2 cost would have to recognize that it had already expired in 2013, so it would be 0.
Any help would be enormously appreciated. Thanks!
Bookmarks