ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Day counter (https://www.excelbanter.com/excel-discussion-misc-queries/204695-day-counter.html)

poohgld

Day counter
 
How can I set up a counter using 1 colum and use each row as a day counter.

ShaneDevenshire

Day counter
 
Hi,

Not sure what you mean but if you want dates in a column increasing by day:

1. Enter the start date in a cell, say A1, in 9/29/08 format.
2. After you enter it put select A1 and drag the Fill Handle down as far as
you need. The fill handle is the bottom right corner square on the selected
cell, your mouse will change from a white plus to a black cross hair.

--
Thanks,
Shane Devenshire


"poohgld" wrote:

How can I set up a counter using 1 colum and use each row as a day counter.


poohgld

Day counter
 


"poohgld" wrote:

How can I set up a counter using 1 colum and use each row as a day counter. I think I need to give more info on this. I need to have the work as a clock so I can see how long an item has been in stock. So it needs to count the days seperate from anything else.



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

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