automatic dates in a column


    Sponsored Links


  • 1. highlight (clolour) select rows
    Dear all, how can I automatically highlight a row as I scroll down? I'd like th text in the row to become bold, and the backround colour in the cell t turn yellow. As I move to the next row text becomes bold, backgroun colour turns yellow, with the previous row reverting to what i currently is. I hope this makes sense - many thanks, catha
  • 2. automatically hit "yes"
    I have a code line which attempts to SaveAs over an existing file. know the answer to "do you want to replace existing file?" will alway be to hit the "yes" button. Can I have VB automatically hit th "yes"button for me? Or do I actually have to hit the "yes" butto every time. Thanks
  • 3. Sorting for Specific words/ numbers from list
    Hi Folks; I am trying to figure out a way to sort some information from data tha appears in a worksheet via an import. The import works like straightforward paste function from another program (in this case Quickbooks). The information pastes the same every time, i.e. dat appears in the same columns every time. These columns have a name in column (ex. A1)and a monetary value in another column (ex. D1). Wha I'm having to try and do is make a formula that will sort similar name and sum up the monetary values that match up with them. The "simila names" are actually numeric codes (ex. 1200, 1300, 1400). The big catc is that, due to the way this program "takes over" with the import/paste the codes do not land in a cell alone. It also pastes along with th code a description. The descriptions can vary (ex. one can sa "1200-labor" the other "1200-materials"). My question is: can you do sort that asks to look at a list of data and have it count only cell that INCLUDE a "similar name" (ex. 1200-hammer is included, 1300-pi not included, 1200-nail included), and have it sum the amounts? My thanks in advance, and please let me know if I'm not being clea enough. -Scot
  • 4. Add Decimal to Cells 2 places to left of number.
    I exported a table from another program that includes fees. Onl problem, the cells are now whole numbers. I need to add a decimal places to the left of the last number. For example, I need to turn: 227500 490 170000 into: 2275.00 4.90 1700.00 Is there a simple way of going about this? Thanks in advance
  • 5. splitting up an IP address
    I want to split up an IP adress as follows and am having no sucess A1 B1 C1 D1 E1 255.356.128.0 255 356 128 0 192 168 0 1 Basically I want to use the "." as the text seperator Thank

automatic dates in a column

Postby gsbbr » Thu, 08 Jan 2004 02:29:23 GMT

I know this is an elementary question, but I do not have a manual, and
the "Help" doesn't open in Excel.  I've used Excel for several years,
made graphs, etc., but I still don't know how to do the following.

The first column needs to be consecutive dates, e.g., 1/1/04, 1/2/04,
1/3/04, 1/4/04, etc.  I have been entering each date in manually, but I
know there must be a simple way for Excel to do this for me.  I have to
enter dates for the entire year.

Can anyone help?  Thanks for your patience.

Message posted from  http://www.**--****.com/ 

Re: automatic dates in a column

Postby Peo Sjoblom » Thu, 08 Jan 2004 02:41:09 GMT

Put the date in the first cell, select the cell again, move the cursor to
the lower right corner of the cell,
copy it down by left clicking and holding down the mouse button while
dragging downwards



Peo Sjoblom

Similar Threads:

1.automatic month/date in a column

How can you enter only the day number in a column ie 2 and have it come up as 
date 02/02 or 2/2 

2.Automatic sum of a column when the other column has the same vaule

Is there an easier way to make the same date only show in one column and add 
the hours of the same dates together in that column than to do it all one by 

Date	                Hours
2008/03/26	1.50 
2008/03/26	7.50 
2008/03/26	1.50 
2008/03/27	1.00 
2008/03/27	10.50 
2008/03/28	8.00 
2008/03/28	1.00 
2008/03/28	5.00 

3.Automatic sum of a column when the other column has the same v

Thanx MAx you're a legend. :P

4.Separating dates from one column to Month, Date, Year columns

I'm looking for a way to take a list of dates that are being cut and pasted 
from an Access Database into excel and separate it so I can sort by Month, 
Day, Year.  The data seems to be recognized in Excel as a date because it 
sorts by the the year.  The format is mm/dd/yyyy.  When I try to change the 
format to anything else, it won't allow the change. column based on existing date column

If your end date is in A1, then in B1 use:


"Spence" < XXXX@XXXXX.COM > wrote in message
news:185f601c41b33$5d5e9c20$ XXXX@XXXXX.COM ...
> What I need to do is simple (I hope.) I have a column
> called END DATE and I need to generate another column
> START DATE based on the END DATE records. Each record in
> the START DATE column needs to be 365 days earlier than
> the date in the existing END DATE record. So, I'm looking
> for something like this:
> 12/04/2005        12/03/2004
> 01/25/2004        01/24/2003
> I'm hoping there's an easy function to save me from having
> to enter all these start dates manually. Any help is
> appreciated.
> Thanks,
> Spence

6. Referencing date column A & time column B to get info from column

7. Calendar Spreadsheet: Column 1 = Date, Column 2 Time of Day, Column 3 memo text field

8. Export to Excel with Automatic Date Name

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 78 guest