ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   can you add a day counter for a colum and row (https://www.excelbanter.com/new-users-excel/204702-can-you-add-day-counter-colum-row.html)

poohgld

can you add a day counter for a colum and row
 
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.

Roger Govier[_3_]

can you add a day counter for a colum and row
 
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.




All times are GMT +1. The time now is 03:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com