can you add a day counter for a colum and row

  • Thread starter Thread starter poohgld
  • Start date Start date
P

poohgld

trying to add a day counter so I can see how long an item has been in stock.
It would need to be able to use 1 coloum and each row in that colum.
 
Hi

Depends how you have your data set up, but assuming date into stock is
column A
=IF(A1="","",TODAY()-A1)
Format>Cell>Number>General
Copy down as required
 
Back
Top