Recurring Date each month with change in a year

Hi
I have a formula I found in airtable for creating recurring events. This appears to mostly address when the year rolls to a new one - so that it changes automatically.

What I’d like to do is in my table have a due date of an item - called RECURRING DATE. In a new column called Due Date - I want a formula that will automatically advance the date to the next due date once current due date goes by. I then want to use that Due Date in a calendar view.

The formula I found is:

DATETIME_PARSE(DATETIME_FORMAT({Recurring Date},'MM/DD')&"/"&YEAR(NOW()))

I tested this with a December 21 date and it does in fact advance the year to the new year, but not the day. So if the recurring date is 1/5/22 and we are now on 1/27/22, I want my due date column to show 2/5/22. Is there a way I can modify this formula to achieve that?

1 Like

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