If you have a date, and you want to create a countdown tracker to that date - which formula should we use?
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!
