🚗

Progress Between Date Range

Master Tag

Tips & Tricks

Created

Jul 2, 2020 08:13 PM

How It Works

https://www.redgregory.com/notion/2020/7/3/notion-formula-find-progress-between-date-range

Usage

dateBetween

Slice

Round

Format

toNumber

Web Tags

Database

Formula

Alternatives

Simplified Progress Bar

Progress Bar Designs

Cover

✂️

Find percentage of week complete inside a date range.

notion image

notion image

Progress

Name

Date 2

Percentage

Emoji

Emoji With Percentage

Jun 28, 2020 → Jul 31, 2020

Jun 28, 2020 → Jul 10, 2020

Jun 28, 2020 → Jul 5, 2020

Jun 28, 2020 → Jul 4, 2020

Jun 28, 2020 → Jul 2, 2020

Jul 5, 2020 → Jul 11, 2020

Formulas

Percentage:

(divide(dateBetween(now(), start(prop("Date 2")), "days"), dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days")) > 0) ? (round(100 * divide(dateBetween(now(), start(prop("Date 2")), "days"), dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days"))) / 100) : toNumber("")

Emoji:

(divide(dateBetween(now(), start(prop("Date 2")), "days"), dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days")) > 0) ? slice("⌬⌬⌬⌬⌬⌬⌬⌬⌬✓", 0, dateBetween(now(), start(prop("Date 2")), "days") / dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days") * 10) : ""

Emoji With Percentage:

if(dateBetween(end(prop("Date 2")), now(), "days") < 0, slice("⌬⌬⌬⌬⌬⌬⌬⌬⌬✓", 0, dateBetween(now(), start(prop("Date 2")), "days") / dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days") * 10) + " " + "100%", if(divide(dateBetween(now(), start(prop("Date 2")), "days"), dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days")) > 0, slice("⌬⌬⌬⌬⌬⌬⌬⌬⌬✓", 0, dateBetween(now(), start(prop("Date 2")), "days") / dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days") * 10) + " " + format(round(divide(dateBetween(now(), start(prop("Date 2")), "days"), dateBetween(end(prop("Date 2")), start(prop("Date 2")), "days")) * 100)) + "%", ""))