Try using the rate function and setting the nper = 360 or 365
(depending on how many days you want to use).

On Jul 15, 1:00*pm, RickS wrote:
I see the formula for calculating annually compounded interest. *Is there a
function formula for daily compounding of interest?

RickS