<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" width="40px" /> The example database below counts the number of days in a date range.

Created by Thomas Frank | Learn Notion Formulas | Notion Basics | Templates | Twitter

</aside>

Days in a Range

// Compressed
dateBetween(end(prop("Date Range")), start(prop("Date Range")), "days")

// Expanded
dateBetween(
    end(
        prop("Date Range")
    ), 
    start(
        prop("Date Range")
    ), 
    "days"
)

© Thomas Frank