automatic dates in a column


    Sponsored Links


  • 1. do not print rows with zero data
    I have a an Exxel 2003 spreadsheet populated from columns A to AN and up to row 976. The problem is that a lot of these rows have zero values which I do not want to print. Also it isn't always the same rows with zero values. I need a macro which detects rows with zero values and only prints out rows which have data in them. [maybe use a 'print' button in the face of the spreadsheet to do this. Please let me know if you have any ideas. Thanks manfareed
  • 2. Relocating reference numbers for many blocks of data
    Dear Sir, I am using Seagate Infordesktop Software which generate report in MS Excel 2002 format. My report is designed in such a way that a reference number located the to right hand coner of each block od data. I need to edit the data so that it appear at the first column of each line. Original Report Format Ref No 1 xxxxx xxxxx xxxx xxxxx xxxxx xxxx xxxxx xxxxx xxxx xxxxx xxxxx xxxx Ref No 2 xxxxx xxxxx xxxx xxxxx xxxxx xxxx xxxxx xxxxx xxxx xxxxx xxxxx xxxx Edited Report Format (what I need) Ref No 1 xxxxx xxxxx xxxxx Ref No 1 xxxxx xxxxx xxxxx Ref No 1 xxxxx xxxxx xxxxx Ref No 1 xxxxx xxxxx xxxxx Ref No 2 xxxxx xxxxx xxxxx Ref No 2 xxxxx xxxxx xxxxx Ref No 2 xxxxx xxxxx xxxxx Ref No 2 xxxxx xxxxx xxxxx Is there any short cut or key board command to do this instead of copy the reference number for each block and past each blank cell one by one? I would be glad if someone who is knowledgable in Ms Excel 2002 could assist me. Thanks Low Seng Kuang Malaysia -- A36B58K641
  • 3. Macro that will unhide then hide rows
    Hi, Would someone be so kind as to assist..please I am trying to create a macro that will unhide and hid rows dependant on the content of column A.
  • 4. insert a hyperlinks into a what-if equations
    does anybody know how to insert a hyperlink into a what-if formula?
  • 5. get Excel array values in Visual Studio VB
    This should be easy but I have researched eight VB books without solving it. How can I get the array values which are in a named (defined) Excel worksheet into an array in Visual Studio VB 2005 (not VBA). I have tried s = wSheet.Range("foo") where "foo" is defined in the workbook as a two dimension array in F15:G15 and s is dimensioned as s(2) in VB. I am also unable to get the values into s when I substitute "F15:G15 for "foo" in the code. Thanks very, very much. Nol Rietman

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