Notion Formula to Compute Age of an Object

In Misc

The following formula calculates the difference in days of a Notion object:

  • dateBetween: Calculates the difference between two dates.
  • now(): Returns the current date and time.
  • prop("Created"): References the “Created” property.
  • "days": Specifies that the difference should be calculated in days.

I use this as a property of many of my Notion objects. To do this:

  1. Create a new property: Add a new property to your database and name it “Days Since Creation.”
  2. Set the property type to “Formula.”
  3. Paste the formula: Enter the formula dateBetween(now(), prop("Created"), "days") into the formula editor.

Leave a Reply