Notion Templates
Notion Templates/
All Templates
All Templates/
Web Clip Dashboard
Web Clip Dashboard/
Date And Time Notion Formulas

Date And Time Notion Formulas

Area
Consulting
Type
Article
Url
https://www.redgregory.com/notion/2022/3/2/9-useful-date-and-time-notion-formulas
URL Name
Twitter Handle
Tag(s)
Notion
Formula
Image
Archive
Archive
Favorite
Favorite
Project
  • FIND HOURS BETWEEN DATE RANGE
    • floor(100 * dateBetween(end(prop("Date Range")), start(prop("Date Range")), "minutes") / 60) / 100
  • FIND DAYS LEFT TO DATE WITH TIME
    • if(formatDate(dateAdd(now(), 1, "days"), "L") == formatDate(prop("Date w/ Time"), "L"), 1, if(dateSubtract(prop("Date w/ Time"), hour(prop("Date w/ Time")), "hours") < now(), dateBetween(dateSubtract(prop("Date w/ Time"), hour(prop("Date w/ Time")), "hours"), now(), "days"), dateBetween(dateSubtract(prop("Date w/ Time"), hour(prop("Date w/ Time")), "hours"), now(), "days") + 1))