How to use dates in a forumula (Excel 2007)

[fireaxe]

I'm trying to get Excel to calculate interest. The formula I want is as follows:

800*1.00112^T

T is the number of days since the deposit (interest is daily). How to I get Excel to automatically calculate T, and post the total amount?

[daddylonglegs]

Hello fireaxe,

If the deposit date is in A1 then use the formula

=800*1.00112^(TODAY()-A1)

format result cell as currency

[fireaxe]

Works perfectly, thanks!