i have 2 dates i.e,
eg: Issue Dt & Expiry Dt. Amount
06.01.10 31.12.10 10000000/-
now i would like to calculate the commission for every quarter from the
issue dt. till expiry dt.i.e, from 06.01.10 next chargeable commission is in
the month of April like that i have to calculate till the expiry dt.
(Amount*.6%)/4+Service tax
so please suggest me some formula wherein if i provide the issue dt. &
Expiry dt. it should give me the commission amount along with the month
automatically till expiry date Eg:- 06/04/10 'X' amount 06/07/10 'X' amount
till 31/12/10....