automatic dates in a column


    Sponsored Links


  • 1. Up,Down,Left,Right stopped working
    Hi I'm not an excel expert, but use the product (XL2002) frequently. Something has caused my cursor movement keys to have an unusual effect in a worksheet. For example, I want to enter a formula to add two cells. Press = (status goes to Enter). Attempt to move cursor to first cell and cursor remains in the formula cell and the whole worksheet moves in the direction of the key pressed but the cursor remains locked in the formula cell. In summary, my cursor remains in the active cell and the worksheet moves rather than the cursor. I've looked through all the options. What simple thing have I missed? TIA Ian B
  • 2. Stop automatically removing leading zeros?
    Our database has a report that pulls information into an Excel file, which I then open. When I open the file, Excel automatically removes the leading zeros, but I need those leading zeros. There are different numbers of leading zeros for each line, so I can't just automatically add a zero to each one or something like that. I don't have access to the report to change how it puts the data in, so I really need a way to tell Excel to NOT auto "correct" this. How can I do this? For the record, I'm using Excel 2002. Thanks!
  • 3. Convert time entered to decimal
    I am trying to create a spreadsheet in which I can enter an actual time (1:13 pm) and have it convert it to a decimal. Tried excel help, to no avail. Output of this is I want an employee to enter their start and end times each day and have the sheet calculate the time spent at work. Thanks!
  • 4. functions searching by date
    I have a list of items that I need to disseminate by date. All of the items are recorded in the form 9/15/2008, and I wish to return results by month. How can I write my vlookup and sumproduct functions to return results by month?
  • 5. IF formula..
    Hey, is it possible to put together a formula which will identify a text arrangement (i.e "Subject A") from a range of cells, G3:P30 - BUT once it's identified it, will tally a numerical value in the adjacent cell? Essentially the data has been input as names with numbers representing a time next to them, i'm looking to draw out the total figure of all those numbers to represent a cumulative time regardless of the amount of times the text arrangement appears - it's just the total numerical figure for each "Subject" i'm interested in..

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 88 guest