Aging Items Based on TODAY

Alanna Maw

Hi,

 

I'm trying to use the TODAY function to work out the age of an item. In Excel I would have a cell with =TODAY(), and do a calculation to subtract the date of the item from this. I have tried using =TODAY(), =TODAY, TODAY, TODAY(), but can't get it to bring back today's date (got #INVALID COLUMN VALUE, #UNPARSEABLE or just the text. Does anyone know how I can use this function?

 

Thanks in advance,

Alanna

Charles DESCOTES

Edit column properties by clicking on the top cell and make sure the column format is 'Date'

=TODAY() will do

 

Is it addressing your issue?

Cheers

Mike Wilday

Charles is correct, if your column containing your formula AND the column containing the date you are checking against is not a date column then your formula will not work correctly. 

Alanna Maw

Thanks very much, it's working now