The simplest way to add a countdown to Notion

Notion does not have a built-in countdown timer that ticks down in real time. What you can create instead is a countdown formula that shows how many days remain until a date you choose, and updates automatically each day. This works in any Notion database and takes about two minutes to set up.

The method uses Notion's formula feature to subtract today's date from your target date. When you open Notion the next day, the number updates without you doing anything. It is not a live timer that counts seconds, but it is reliable for tracking days until a important date, event, or goal.

Key Takeaways

  • Notion countdowns use a formula that subtracts today from your target date, showing days remaining instead of a live timer.
  • You need a database with a date property for your target date and a formula property to calculate the difference.
  • The formula dateBetween(prop("Target Date"), now(), "days") shows how many days are left.
  • You can customize the display to show weeks, months, or add text like "5 days until launch".
  • Conditional formatting lets you change the color as the countdown gets closer to zero.

Setting up a database with a date property

Start by creating or opening a Notion database. This can be a table, board, or any database type. Add a new property and name it something like "Target Date" or "Event Date". Set the property type to Date. This is where you will enter the date you want to count down to.

In the same database, add another property for the countdown itself. Name it "Days Until" or "Countdown". Do not set this to Date — instead, set it to Formula. This is where Notion will calculate and display the number of days remaining.

Writing the countdown formula

Click into the Formula property you just created. In the formula editor, paste this formula:

dateBetween(prop("Target Date"), now(), "days")

Replace "Target Date" with the exact name of your date property if you named it something different. This formula takes your target date, subtracts today's date from it, and shows the result in days. If your target date is January 15 and today is January 10, it will show 5.

Click Done. Notion will now calculate the countdown for every row in your database. If a row has no target date filled in, the formula will show an error — that is normal and does not break anything.

Customizing what the countdown displays

The basic formula shows only a number. You can make it more readable by adding text around the number. Use this formula instead:

prop("Target Date") == empty ? "No date set" : dateBetween(prop("Target Date"), now(), "days") == 1 ? "1 day left" : dateBetween(prop("Target Date"), now(), "days") + " days left"

This version shows "No date set" if the date property is empty, "1 day left" if there is exactly one day remaining, and "X days left" for any other number. You can edit the text to say whatever you want — "days until launch", "days to important date", or anything else.

If you want to show weeks instead of days, change "days" to "weeks" in the formula. For months, use "months". You can also combine them — for example, showing both weeks and days — but that requires a longer formula.

Using conditional formatting to highlight urgency

Once your countdown is working, you can make it change color as the important date approaches. This helps you spot urgent items at a glance. Click the three dots next to your countdown property and select Edit property. Scroll down to Conditional formatting.

Click Add a condition. Set it to change the color when the countdown is less than 7 days, for example. You might make it yellow for 7 days or fewer, orange for 3 days or fewer, and red for 1 day or fewer. Each condition is a separate rule, so add as many as you want.

The color change applies to the entire cell, making it impossible to miss when something is coming due soon. This is especially useful if you have a long database and do not want to scroll through every row to find what needs attention.

Countdown formulas for specific use cases

If you want to count down to a specific time of day, not just a date, use this formula:

dateBetween(prop("Target Date"), now(), "hours")

This shows hours remaining instead of days. You can also use "minutes" or "seconds", though seconds will not update in real time — it only updates when you refresh the page.

For a countdown that shows negative numbers after the important date has passed (useful for tracking how overdue something is), the basic formula already does this. If your target date was yesterday, it will show -1. If you want to show "Overdue" instead of a negative number, use:

dateBetween(prop("Target Date"), now(), "days") < 0 ? "Overdue" : dateBetween(prop("Target Date"), now(), "days") + " days left"

Troubleshooting common countdown problems

If your formula shows an error, the most common cause is a typo in the property name. The formula must match your date property's name exactly, including capital letters and spaces. Copy the property name directly from your database and paste it into the formula to avoid mistakes.

If the countdown shows the wrong number, check that your date property is actually set to the Date type, not Text. A date stored as text will not calculate correctly. You can also verify the formula is using the right date by clicking on a specific row and checking what date is actually stored there.

If you want the countdown to reset each day but it is not updating, refresh your Notion page. Notion updates formulas when you load the page, not continuously in the background. Closing and reopening Notion will force an update.

Frequently Asked Questions

Can I make a countdown that shows hours and minutes together?

Yes, but it requires a longer formula. You would calculate total hours, then divide to get hours and minutes separately. Most people find it simpler to pick one unit — either hours or days — depending on how urgent the important date is. A countdown showing "48 hours" is usually clearer than "1 day, 23 hours, 47 minutes".

What happens to the countdown after the important date passes?

The formula will show a negative number, like -2 for two days past the important date. You can use conditional formatting to change the color to gray or red, or use the "Overdue" formula shown above to display text instead of a number.

Can I use a countdown in a Notion page, not a database?

Not directly — formulas only work in database properties. However, you can embed a database view into a page, which lets you see your countdowns on the page itself. Create the database with your countdown formula, then use the embed or synced block feature to display it where you want.

Does the countdown update automatically if I change the target date?

Yes. As soon as you change the date in the Target Date property, the countdown recalculates. You do not need to do anything else — the formula updates when ready.