Use day of the year to calculate countdown


#1

Hi - I’m trying to do a simple table that calculates countdowns. For example, the first column would be a date (let’s say my anniversary) and the second column would calculate how many days the event is from the current date. I found the formula DDD but I can’t get it to work.


#2

You have to use DATETIME_DIFF([date1], [date2], 'units').

Doc: https://support.airtable.com/hc/en-us/articles/203255215-Formula-field-reference#date_and_time_functions