I am a beginner in Excel, so bear with me. I have a spreadsheet that tracks
my investments, and calculates the daily return as a percentage, which I then
have averaged to show the average daily yeild. I have come up with another
formula that shows compounding interest, but it needs the APY to get proper
calculation. What I want to be able to do is convert the average daily yield
to an APY, which will change as daily average changes. Everything I have
tried so far has not worked. Any help would be greatly appreciated.

Thanks