| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Different colum widths for same colum in different areas of worksh | Excel Worksheet Functions | |||
| Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Linear Mode
