Create a formula to create a selected range of dates.

Copper Contributor

I am trying to create a daily compounding interest calculator.

I would like the calculator to create a range of results within a nominated date range e.g. 1/03/2023 and 1/04/2024.

Can I create a formula to manage this function?

Many thanks


2 Replies
This is a nasty problem. You might get away with =SCAN to carry the interest. In my painful experience, you will need HRECURSE (to carry more than one result, eg NPA).


Thank you ecovonrein for your response. Unfortunately, this is way outside my limited knowledge of Excel. But appreciate your reply.