How to select a column of dates

Sierra Randall

Hello,

I have a column of report due dates (date) and I am trying to create a column that gives the number of dates until each different report is due. I have tried =date:date - TODAY() which does not work. It works when I specify the cell [date]1-TODAY(). I need this to display for each row.

Mark Cronk

Hi @Sierra Randall ,

Try:

=Date@row-today()

Mark