Hi: I am trying to find an excel formula to use compounding backwards and find monthly and daily growth rates while having an annual growth rate. Example: Year 1 sales = 100. Year 2 Sales = 200. What is the daily growth rate to get from 100 to 200? From there I can create a table with Day | daily rate | Value at day [x] and adjust each month's sales forecast by number of days in the month.

Thanks in advance