automatic dates in a column


    Sponsored Links


  • 1. Table in word
    Hi all, i want to put data into a word doc from excel..i know how to pull data(from Excel) and put it in a textbox(in word). But i want to paste the data in some cells in a table(in word).for eg say 2nd row 3 rd column. can anyone help me in this....Thanks in advance for all helps... Jithu
  • 2. how to sort number properly in excel?
    I notice that unlike Access, Excel doesnt sort numbers in their true numerical sequence. e.g. a varying digit ID field I have ends up sorted as such: 1008 1009 101 1010 1011 etc. Obviously 101 shouldnt be between these values, it should be way before these particular ones. The column is formatted as 0 dp numbers. Is there a simple trick with formatting/ options etc. that will let me see the results in true numerical order? I wondered about forcing them to all have the same amount of digits with custom format maybe... Thanks in advance
  • 3. Excel 2007 Freezing
    I have Excel 2007 and am having a problem when working with multiple excel files at the same time. Either when opening an additional Excel file or when the file autosaves excel will freeze for a period of time (approx 5+/- min) and then become available again. Does anyone have any idea what could be causing this? The files are located on a server but the server seems to be working fine with other file types.
  • 4. Incrementing the date
    I'm trying to print a daily register, with the date on the top, is it possible to increment the date for every day of the month to save having to change the date 30 odd times? I would like to print them off all in one go without having to change the date several times.
  • 5. Time - How do you see if a time value is between 2 values?
    I want to perform a conditional formating in Excel that says: If the time is between 07:00 and 13:59 then turn the cell border red and turn the font red. if the time is between 14:00 and 07:00 turn the cell green. Condition 1 This works to turn the cell green: =$F$4<=$E$4 Condition 2 This works to change the font red: =$F$4>=$E$4 Condition 3 This does not turn the cell green: =$F$4>TIME(14,0,0) Does anyone have any idea on how can I code this so that it will work? Thanks

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