end
Learn how to use the end function in Notion formulas.
The end() function returns the end date from a date range. It accepts a single date argument.
1
end(date)
end() is useful for obtaining the end date from a Date property which contains a date range.
When you pass a single date as the argument - i.e. from a Created Time/Last Edited Time property, or a timestamp - end() simply returns that date.

1
// Assume a property "Date" exists, with
2
// a row value of June 23, 2022 β†’ June 27, 2022
3
end(prop("Date")) // Outpuut: June 27, 2022

It’s useful to note that date math functions like dateAdd and dateSubtract return a date object that does not contain a date range - even if their argument does include one.
When these functions are passed a date object that includes a range, they only use a start date.
For this reason, the following two formulas will return the exact same date:
1
// Assume a property "Date" exists, with
2
// a row value of June 23, 2022 β†’ June 27, 2022
3
start(dateAdd(prop("Date"),30,"days")) // Output: July 23, 2022
4
​
5
end(dateAdd(prop("Date"),30,"days")) // Output: July 23, 2022
Therefore, you must use the end() function within your date math function if you wish to operate on the end date in a date range:
1
// Assume a property "Date" exists, with
2
// a row value of June 23, 2022 β†’ June 27, 2022
3
dateAdd(end(prop("Date")), 30, "days") // Output: July 27, 2022

The example database below contains several events that are happening over multiple days. The Date Range property displays their start and end dates, while the Current State formula property determines whether the event has passed, is currently ongoing, or is still in the future.
Finally, both the Table and Board views of the database are grouped by the Current State formula’s three possible outputs.

end
College Info Geek on Notion

1
// Compressed
2
if(dateBetween(start(prop("Date Range")),now(),"days") > 0,"Future Events",if(dateBetween(end(prop("Date Range")),now(),"days") >= 0,"Currently Active","Past Events"))
3
​
4
// Expanded
5
if(
6
dateBetween(
7
start(
8
prop("Date Range")
9
),
10
now(),
11
"days"
12
) > 0,
13
"Future Events",
14
if(
15
dateBetween(
16
end(
17
prop("Date Range")
18
),
19
now(),
20
"days"
21
) >= 0,
22
"Currently Active",
23
"Past Events"
24
)
25
)
This formula uses a nested if-statement and dateBetween to first check if the current date (determined with the now function) is before the start of the event's date range.
If it is not, the next level of the if-statement checks to see if the current date is before the end date of the date range (determined with end()).

​
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 Formula
Date Math within start() and end()
Example Database
View and Duplicate Database
"Current State" Property Formula