#1
|
|||
|
|||
interest to a cell
Hi I have a spreadsheet with 12 cells (months of the year) the interest rate is 5.35% with a balance of say £5000 I am trying to display the interest in each cell ,it would be different for each month due to the amount of days in the month would I have to write a formula for each cell or is there any way that a formula might know how many days there are in each month.
hope this makes sense it's not compound interest it's just straight forward interest per month. many thanks bjj |
#2
|
||||
|
||||
Here is a formula for the number of days in a month. Use this to calculate your monthly interest. =EOMONTH(B1,0)-B1+1
|
#3
|
|||
|
|||
Hi thanks for your quick reply I will give that a go.
bjj |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell color based on cell value as compared to another cell va | COgreywolf | Excel | 9 | 09-25-2018 12:28 PM |
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow | FUGMAN | Excel Programming | 7 | 02-05-2017 08:37 AM |
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C | rick10r | Excel | 1 | 07-05-2016 12:07 PM |
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? | bharathkumarst | Excel | 7 | 10-13-2014 10:25 AM |
Style and spelling issue of interest | Ulodesk | Word | 4 | 05-19-2011 03:22 PM |