Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula for showing days remaining for a task?

Topic Labels: Formulas
Solved
Jump to Solution
541 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, what formula can I use to show many days remain for a task?

For example, if there are 4 days remaining before the Due Date, I’d like that cell to read “4”

I tried using a formula from another table but it didn’t work. The existing formula was: IF({Name (from Due Date)}, DATETIME_DIFF({Name (from Due Date)}, TODAY(), ‘days’))

My new formula is: IF({Follow Up Date}), DATETIME_DIFF({Follow Up Date}), TODAY(), ‘days’)) - but this one doesn’t seem to function correctly.

Any help is greatly appreciated. Thanks! Christopher

Screenshot 2021-05-14 at 20.47.47

1 Solution

Accepted Solutions

Hi @Torus_Global - you’re nearly there. There’s a couple of stray RH brackets that must have got copied over. Try this

IF({Follow Up Date}, DATETIME_DIFF({Follow Up Date}, TODAY(), 'days'))

See Solution in Thread

2 Replies 2

Hi @Torus_Global - you’re nearly there. There’s a couple of stray RH brackets that must have got copied over. Try this

IF({Follow Up Date}, DATETIME_DIFF({Follow Up Date}, TODAY(), 'days'))

Bingo, that was it. Thanks, @JonathanBowen!