calculation formula...

[wann]

Hello... I'm making a spreadsheet calculator to calculate my fixed deposit account based on multi-tier rate percentage p.a which then calculate on number of days of the current months so that I know how much interest I've earned for the current month.

For example:

Multi-tier percentage is based on amount of deposits range as 50 - 499 is 2%, 500 - 5000 is 2.25%, 5001 - 10000 2.5%, 10001 - 20000 2.75%, 20001 - over 3%.

I need a formula solution for number of days of the current month and year (auto calendar) so that I don't have to edit the cell to tell number of days to calculate for my solutions below...

I've have entered 1000.00 as my opening accounts which then * by my tier percentage 2.25% p.a which then * again by number of days in the current month as for January which is 31 days then / by number of days in the year which is 365 or 366 days which = 1.91 interest earned for that current month.

My question is... If I have a month "Jan" entered in a cell, can excel calculate number of days for the current month? Is it possible? or Is this the only method can I used which I have to edit manually in each cells for number of days for each months which I'm currently doing now.

Please see my attached spreadsheet for details...

[oldchippy]

Hi wann,

I've altered your months to actual dates so that the number of days per month and per year can be calculated.

Alter to suit your layout

oldchippy

[wann]

Hi wann,

I've altered your months to actual dates so that the number of days per month and per year can be calculated.

Alter to suit your layout

oldchippy

Oh yes! That will do... thanks!

PS: Any possible formula or other method similar to this is very appreciated.

[Bryan Hessey]

Hi wann,

I've altered your months to actual dates so that the number of days per month and per year can be calculated.

Alter to suit your layout

oldchippy

Hi Oldchippy, but a cynic would say that, used in advertising, you could have difficulty explaning M7
--