Create a formula to create a selected range of dates.

Question

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

ecovonrein · Answer

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/3562417

grant888 · Answer

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

Forum Discussion

Create a formula to create a selected range of dates.

Share

Resources