abs

Learn how to use the abs function in Notion formulas.

The abs() function calculates the absolute value of a number.

abs(number) number.abs()

A number’s absolute value is simply how far it is away from zero. Therefore, the absolute value of a negative number is equal to its positive equivalent – e.g. abs(-5) == 5.

In mathematical notation, absolute values are expressed by wrapping a number in || signs:

\(|-12\;| = 12\)
abs(-42) /* Output: 42 */ 42.abs() /* Output: 42 */

Notion’s dateBetween function subtracts the second argument from the first, and returns a number depending on the specified unit of time (e.g. “hours” or “seconds”).

If the second argument is a later date than the first argument’s date, dateBetween() will return a negative number. The formula in the table below uses the abs() function to ensure that the output is always positive.

Notion – The all-in-one workspace for your notes, tasks, wikis, and databases.
A new tool that blends your everyday work apps into one. It’s the all-in-one workspace for you and your team
thomasfrank.notion.site
abs(dateBetween(prop("Date 1"), prop("Date 2"), "seconds"))

Other formula components used in this example:

dateBetween – Thomas Frank
thomasjfrank.com
About the Author

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.

🤔 Have an UB Question?

Fill out the form below and I’ll answer as soon as I can! ~Thomas

🤔 Have a Question?

Fill out the form below and I’ll answer as soon as I can! ~Thomas