Hi everyone.

I have a spreadsheet that is formatted by a macro. The end result is dates in column C (D/MM/YYY) and amounts in Column D. I need to calculate interest (rate 10%) on these amounts.

So for example any amounts dated Jan 08 will attract interest commencing 1st Mar 08, any Feb 08 amounts start accuring interest from 1st Apr 08 etc.

I need VBA code that will calculate interest and put the result in column E. Can anyone help please?

Thank you.