formula changes help

[ehsas]

OVERDUEINT02980388660011.xls
	A	B	C	D	E	F	G	H
2						INT	0.05%
3						AMT	1583
4	date				duedate	duedate	intperday	totalint
5	25-Jun-99	#N/A	#N/A	#N/A	25-May-99	32	1.538676	1.5387
6	25-Mar-00	#N/A	#N/A	#N/A	25-Feb-00	30	0.769338	2.3080
Sheet2

Looking into above excel file I need help in calculating the interest due.The due date is 25 of each month
looking into date between e5 and a5 the a/c is due for two month and also looking the date between e6 and a6 a/c is also due for two month but the problem is because the interest is calculating on due date which is number of days(f5 and f6) the interest is differ where it needs to be exact.for f5 it calculating at to months where for f6 it calculating for one month.Please into the formula in g5 and g6 for same.Could any please help where i can calculate same based on number of months on due date.Regards,

 

[ehsas]

ANY ONE COULD HELP PLEASE.Regards

 

[ehsas]

any help please,Regards.

 

[PaddyD]

Could you try to explain your problem a little more clearly. Please give a detailed breakdown of the calculation you need, including an indication of the expected result.

Paddy

 

[plettieri]

In addition what PaddyD asks, might you also explain the basis for "0,32,62" in cell G6 (......MATCH(F6,{0,32,62}.....).

In general it seems you have doubled up on the calculation some where....are there some ranges that are being used that are critical to the calculation that don't show up on your short presentation?

A little more info would be helpful...

pll

 

[PaddyD]

on reflection, this sounds familiar:

http://www.mrexcel.com/board/viewtopic.php?topic=22573&forum=2

is this the same problem?

paddy

 

[plettieri]

It does look like a continuation of that problem...but the latest issue does not seem to indicate a late fee implication as the first proiblem did.....seems like only an interest calc on a principal amount on the second problem.....

I guess we await the authors feedback.


pll

 

[ehsas]

No this is not similar problem.Regards,

 

[PaddyD]

In which case,

" Could you try to explain your problem a little more clearly. Please give a detailed breakdown of the calculation you need, including an indication of the expected result. "

Paddy