lets(
dt, prop("Date").formatDate("L"),
db, prop("Date").dateBetween(now(), "days"),
ifs(
dt == now().formatDate("L"), "Due Today",
dt == now().dateAdd(1, "days").formatDate("L"), "Due Tomorrow",
now() > prop("Date"), "Overdue",
db > 2, db + " days left"
)
)
<aside> ⚠️ The database above uses a formula to calculate the Date property so the example stays current. The Status formula will work as required when using a regular date property.
</aside>
<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
</aside>