Thanks Tim, are you suggesting I do this with the NPER or PV formulas? But
where do I put the 360 basis, in the formula as described in Excel Help?
Which component is the basis? NPER(rate, pmt, pv, fv, type)


RickS

--
Confused...


"Tim879" wrote:

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