"bryantsheriff" wrote:
i am trying to calculate daily compounding interest on a certificate of
deposit, but don't want to take up 365 lines to do so. is there formula
that can calculate it more simply?

If A1 is the principal value of the CD, A2 is the annual interest rate,
and A3 is the length of the term of the CD in days, then:

=fv(A1/365, A3, 0, -A2) - A2

computes the total interest.