Forum Discussion
Future Value of a daily savings account
Since you end your request with the statement "Any help would be appreciated" I'm going to take you at your word and not try to actually solve it (although I'll be interested in the solution)...
If I were in your place, I'd look at one of the cash flow functions. IRR and XIRR in particular seem suited. I use the latter in calculations involving an irregular series of returns for some investment strategies where there are cash transactions both in and out to consider, varying amounts.
It's not a simple or single formula that it relies on, but a series of transactions, and given your situation, you may need (absent some formula based on calculus perhaps) to just set forth a daily "deposit" next to a series of dates....
OK, as I said, I'll be interested and now that I've responded I'll be able to see what other Excel folks come up with.
Have fun!