Great Product by the name of EXCEL

Look at XNPV or XIRR

The X means that the payment stream is not smooth. Inputs are actual dates
and amounts.

pretty sure it uses 365 day compounding and the XNPV of a future date should
give coumpounded interest for amounts deposited.

start with some simple inputs to get a handle on it, but this can be made to
do what you are asking

"Mac" wrote:

[Excel 2003]
I want to calculate compound, variable interest on an account consisting of
multiple deposits of irregular amounts and and irregular deposit dates.
It would be best if it could calculate on actual calendar dates, not just
30-day months/360 days. Also, it would be best if interest could be
compounded daily, rather than any larger period.
Does anyone happen to know a way to program this or a site that I might
purchase it from?
Thanks.