// Assume a property called "Date" with a current row value
// of June 1, 2022
dateAdd(prop("Date"),-3,"months")// Output: March 1, 2022
This example database demonstrates a very simple way to track recurring tasks in Notion. The Next Due formula returns the next due date for the task, based on the current Due date and the number of days specified in the Interval (Days) property.
The value from the Unit property is concatenated with "s" in order to make it conform to dateAdd()'s accepted values.
Of course, handling recurring tasks can get much more complicated if you do want to handle overdue tasks. If you want to see just how big a Notion formula can get, check out the recurring tasks formula we developed for my Ultimate Tasks and Ultimate Brain templates: