
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 27, 2020 01:08 PM
Hi There! I have a series of tasks with deadlines. The field next to “Deadline” is a countdown titled "Days Left’ with the amount of days left until the task is due. However, I don’t yet have/need deadlines for some of the tasks, so the Deadline field is sometimes empty which results in NaN.
The formula I used for “Days Left” is DATETIME_DIFF(Deadline, TODAY(), ‘days’)
I’ve tried a few different IF formulas to remove NaN but I keep getting errors. Can anyone help me out here?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 27, 2020 01:24 PM
Welcome to the community @Kathryna_Hancock!
You can use an IF statement to only run your existing formula if there is a date in the Deadline field. Here’s how that should look:
IF(Deadline, DATETIME_DIFF(Deadline, NOW(), 'days'))
Notice that I also switched out TODAY() with NOW()
because NOW()
uses the exact current day and time, while TODAY()
defaults to the current day at 12:00am.
You can also find more tips on troubleshooting common formula errors like NaN
here: https://support.airtable.com/hc/en-us/articles/360034619694-Common-formula-errors-and-how-to-fix-the...

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 27, 2020 01:24 PM
Welcome to the community @Kathryna_Hancock!
You can use an IF statement to only run your existing formula if there is a date in the Deadline field. Here’s how that should look:
IF(Deadline, DATETIME_DIFF(Deadline, NOW(), 'days'))
Notice that I also switched out TODAY() with NOW()
because NOW()
uses the exact current day and time, while TODAY()
defaults to the current day at 12:00am.
You can also find more tips on troubleshooting common formula errors like NaN
here: https://support.airtable.com/hc/en-us/articles/360034619694-Common-formula-errors-and-how-to-fix-the...

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 27, 2020 03:00 PM
Thank you! That worked!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 27, 2020 03:15 PM
You’re welcome @Kathryna_Hancock!
