Create a formula to create a selected range of dates.

New 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

Grant

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). https://techcommunity.microsoft.com/t5/excel/hrecurse-instead-of-makearray-recursing-lambda/m-p/3562...

@ecovonrein 

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