Days left in Notion

days-left.js

lets(
  nowVal, now(),
  
  /* We need now as just a date with no time */
  nowDate, nowVal.formatDate("YYYY-MM-DD").parseDate(),
  dueDate, prop("Due Date").formatDate("YYYY-MM-DD").parseDate(),

  /* Days between now and the due date */
  days, dateBetween(dueDate, nowDate, "days"),

  /* Now we switch on the conditions */
  ifs(
    /* Date is unset */
    empty(prop("Due Date")), "No date".style("grey", "i"),

    /* No diff is today */
    days == 0, "Today".style("red"),

    /* +1 is tomorrow */
    days == 1, "Tomorrow".style("orange"),
    
    /* -1 is yesterday */    
    days == -1, "❗️ Yesterday".style("red", "b"),

    /* well overdue! */
    days < -1, ("‼️ " + abs(days) + " days ago").style("red", "b"),

    /* positive days remain */
    days + " days left"
  )
)