Auto increasing date column

Hi everyone, I’m a new airtable user who needs some advice how to perform the following task efficiently. I want to track some subscriptions like this:

The renewal date column should auto increase under this circumstances:

If interval monthly:
And {Renewal Date} <= Today()
{Renewal Date} = DATEADD({Renewal Date}, 1, ‘months’)

If interval yearly:
And {Renewal Date} <= Today()
{Renewal Date} = DATEADD({Renewal Date}, 1, ‘year’)

I have already tried several ways, but I am not very satisfied with them. Thank you :slight_smile:

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.