suggest an expresion

[#1]

Dear experts,

I have attached a sample file in my interest calculation.

I'm looking for an idea to develop this  01. to calculate the due interest for a  required date.

                                                        02. how can i link the interest calculation with a calendar.

Thkx & Rgds,

Priyantha.