Date field minus 'TODAY()
Could someone please explain why the following doesn't work or a solution:
I have a date column with a mix of dates both past and future. The next column is a column to say how many days till this date occurs. Therefore if it is in the future (i.e. date is the 30/10/20) then the second column needs to say 534. If it was it the past (i.e. date is the 13/11/18) then the second column needs to say -183.
I have managed to get it working in excel with a simple formula in the second column '=DATECOLUMN-NOW()' but unfortunately '=DATECOLUMN-TODAY()' won't work in SmartSheet.
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!