How do I create a recurring date column?

1

Hey guys, I’m creating an expense tracker table, and I suck at figuring out how to create the Next renewal date. How can I make it so that it would automatically jump to the latest cycle?

To make things more complicated, I have some entries that are monthly, annually and every 6 or 8 months :joy:

Would appreciate any help I can get! :pray:t3::pray:t3::pray:t3:

CleanShot 2023-09-26 at 10.34.06@2x
CleanShot 2023-09-26 at 10.34.06@2x2794×1208 305 KB

Here’s the link to the table https://coda.io/d/_d3ERsNfPgRX/Demo_sucBB

2

Dear @Duy_Nguyen,

I suggest to have a look to this post: Date Frequency Control - #9 by BenLee

Credits: @BenLee

1 Like