assume annual rate is r (like 0.1) and compounded daily.
the APY = (1+r/365)^365-1, format as percentage.

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Tool & Training Material for Download
==================================
"bryantsheriff" wrote in message
...
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?