Hi

Depends how you have your data set up, but assuming date into stock is
column A
=IF(A1="","",TODAY()-A1)
FormatCellNumberGeneral
Copy down as required

--
Regards
Roger Govier

"poohgld" wrote in message
...
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.