ok..in sheet1, the 1st amountt is $1,000 and I need to calculate the int from 1/1/2010 to 4/30/2013.
the 2nd is $2,000.00..int from 5/1/2001 to 12/31/2011..and so on.
I need the macro to be able to go to the rates sheet and pick up the correct rates for each period so for instance, the rates for the 1st period will be the base on int interval l 1/1/2010 - 1/4/2012 @ 3.25%
1/5/2012- 9/13/2012 @ 3.25%
9/14/2012 - 4/30/2013 @ 3.25%
Now these happen to be the same rate for all the intervals, but in the 2nd amt for $2,000, it is more complicated.
hi Richard..i just sent the link with the wiki id..hope u got it. thanks.
Please see the file. Thanks.
I apologize as we have not yet been able to find another professional to assist you. Would you like me to continue to search for someone to assist you or would you like for me to close your question at this time?
Thank you for your patience,