can you add a day counter for a colum and row

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.
 
R

Roger Govier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Day counter 2
Calculation 2
Counting Enteries 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How do I set a rule for moving one cell down + one left in Excel? 6
how can I get the total hrs of a delay when it is greater than 24 2
Counter stops working 4
Cursor, row, colum, beam 3

Top