I have an invoice amount, a due date and a current date, the interest will apply between those two dates. Currently I need type of the interest periods that sit between those two dates and assign the interest rate for each period. If I have the interest rates by periods in a different table, how I can cross reference these with my main sheet?
*In sample spreadsheet* The periods I have to manually type out is in the interest period column, I manually check these against the other table.
Any help would appreciated thanks.
*In sample spreadsheet* The periods I have to manually type out is in the interest period column, I manually check these against the other table.
Any help would appreciated thanks.