Formula to countdown days

[john1]

If you have a date, and you want to create a countdown tracker to that date - which formula should we use?

[rachitk]

Please use this formula:

DATETIME_DIFF({Due-Date}, TODAY(), "days")

Basically the TODAY () function gives you the today’s date and then you can use the difference with your {DUE-Date} column to count the number of days.

Quick example in the screenshot below:

Hope this helps!