Formula Components

Formulas and Databases

Reference

Formula Examples

dateAdd

Learn how to use the dateAdd function in Notion formulas.

1

dateAdd(date, number, string [from unit list])

It requires three arguments in the following order:

Accepted units include:

- βyearsβ
- βquartersβ
- βmonthsβ
- βweeksβ
- βdaysβ
- βhoursβ
- βminutesβ
- βsecondsβ
- βmillisecondsβ

1

// Assume a property called "Date" with a current row value

2

// of June 1, 2022

3

dateAdd(prop("Date"),3,"months") // Output: September 1, 2022

4

β

5

dateAdd(prop("Date"),5,"days") // Output: June 6, 2022

You can nest multiple

`dateAdd()`

functions to add multiple different types of units to a date:1

// Assume a property called "Date" with a current row value

2

// of June 1, 2022

3

dateAdd(dateAdd(prop("Date"),3,"months"),5,"days")

4

// Output: September 6, 2022

`dateAdd()`

accepts negative values:1

// Assume a property called "Date" with a current row value

2

// of June 1, 2022

3

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.

dateAdd

College Info Geek on Notion

1

// Compressed

2

dateAdd(prop("Due"),prop("Interval"),prop("Unit") + "s")

3

β

4

// Expanded

5

dateAdd(

6

prop("Due"),

7

prop("Interval"),

8

prop("Unit") + "s"

9

)

As you can see, this formula is quite simple. If you're not worried about accounting for overdue tasks, returning the "next due" date for a recurring task is quite easy.

Using

`dateAdd()`

, all we are three pieces of information:- The original due date
- The unit (e.g. days, weeks, months, years)

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:

Next Due

College Info Geek on Notion

β My name is Thomas Frank, and I'm a Notion-certified writer, YouTuber, and template creator. I've been using Notion since 2018 to organize my personal life and to run my business and YouTube channel. In addition to this formula reference, I've created a free Notion course for beginners and several productivity-focused Notion templates. If you'd like to connect, follow me on Twitter.

Last modified 20d ago

Copy link

On this page

Example Formulas

Example Database

View and Duplicate Database

"Next Due" Property Formula