Forum Discussion

Devon1990's avatar
Devon1990
Copper Contributor
Feb 07, 2024

Annual, Biannual, Monthly Calculations

Hello, I am trying to make a dashboard that will show which subscriptions I have coming up. What I need is to know how to calculate the next renewal date in order to better plan my finances. Just for...
excel
Formulas and Functions
rachel's avatar
rachel
Steel Contributor
Feb 08, 2024

Devon1990 

 

Hi,

 

I think the easiest is a while loop.

 

e.g for annual, you can use 4 Aug 2022 + 12months + 12months + ... until the result hits "Today".

 

I added a lambda to achieve this. (If you are using office365). 

 

 

example spread sheet attached:

 

 

Resources