Does anyone know how to figure the interest on a CD at
the bank when the interests are compounded daily each
month? Our bank uses the rule of 365 days in a year rule.
My father-in-law wants to know how much he will get each
month. It appears to me that formula is needed for each a
day of the month. But I do not understand how the banks
could you tell you but it is so hard for you to do it.
There must be an easier way of doing it in Excel 2002 is
what I have.

Tom