Notion Templates
Notion Templates/
All Templates
All Templates/
⚒️
Days Remaining To Deadline
⚒️

Days Remaining To Deadline

Master Tag
Tips & Tricks
Created
Aug 12, 2020 12:16 PM
How It Works
https://www.redgregory.com/notion/2020/8/12/notion-deadline-tip-count-days-remaining-and-days-overdue
Usage
Abs
dateBetween
formateDate
Format
Web Tags
Database
Formula
Alternatives
Cover
Days Remaining And Days Overdue
Name
Deadline
Days Remaining
Task 1
Dec 10, 2021
Task 2
Dec 9, 2021
Task 3
Dec 8, 2021
Task 4
Dec 14, 2021
(With Done Checkbox) Days Remaining And Days Overdue
Name
Deadline
Days Remaining
Done
Task 1
Dec 10, 2021
Done
Task 2
Dec 9, 2021
Done
Task 3
Dec 8, 2021
Done
Task 4
Dec 14, 2021
Done
 

if(formatDate(prop("Deadline"), "MMM DD, YYYY") == formatDate(now(), "MMM DD, YYYY"), "Due Today ✅", if(dateBetween(prop("Deadline"), now(), "days") > 0, format(dateBetween(prop("Deadline"), now(), "days") + 1) + " Days Remaining", if(dateBetween(prop("Deadline"), now(), "days") > -1, "Due Tomorrow 🔜", if(dateBetween(prop("Deadline"), now(), "days") < 0, format(abs(dateBetween(prop("Deadline"), now(), "days"))) + " Days Past Due ⭕️", ""))))
Without done checkbox
if(prop("Done") == false, if(formatDate(prop("Deadline"), "MMM DD, YYYY") == formatDate(now(), "MMM DD, YYYY"), "Due Today ✅", if(dateBetween(prop("Deadline"), now(), "days") > 0, format(dateBetween(prop("Deadline"), now(), "days") + 1) + " Days Remaining", if(dateBetween(prop("Deadline"), now(), "days") > -1, "Due Tomorrow 🔜", if(dateBetween(prop("Deadline"), now(), "days") < 0, format(abs(dateBetween(prop("Deadline"), now(), "days"))) + " Days Past Due ⭕️", "")))), "Complete")
With done checkbox