automatic dates in a column


    Sponsored Links


  • 1. Gremlin in Excel 97 running on Windows XP Home edition
    When transferring Excel files to Excel 97 installed on Windows XP Home Ed. from Excel 97 installed on Windows 95 or 98, the "Save as" window shows only the first letter of the file's name and will not accept the full name of the file even when completed manually by typing it in. The file saves only as "(First letter).xls". The file name must be completed in Excel once the file has been saved by going into the "Open file" menu window and right-clicking on the file name, then typing in the full name. However, it then automatically adds in the ".xls" suffix a second time. Excel 97 appears to be working normally otherwise. I have also installed Office service packs 1 and 2 since this problem was noticed, but to no avail. Any ideas anyone? Tks in advance MatthieuR 04.09.16
  • 2. how to enter a value, and have it SUMMED with the existing cell co
    An Excel cell contains, say= 4. How do you enter, say=2, and have the result = 6? (not COPYING and Paste As ...)
  • 3. Excel VBA...Linking to a vba picture holder
    Help Please! I've got an excel prog that uses a hyperlink to display a .jpg from directory. It works fine but opens psp7 every time and then psp asks i i want to save it again. I've put a vba image box on the spreadsheet BUT have got totally los trying to link it to the hyperlink. a quick bit of info... Col A , rows 1 to 199 contain links to the folder with images in. Col B is data to be copied to an xml file which comes from Gmax (fltsim 2004 stuff). I've put the vba image box in col D and of course it shows a piccy.. If I alter the properties to the full path. Is there any way of linking the hyperlink so that instead of startin psp7 it will put the pic straight into the box ??? Any help or pointers in the right direct appreciated.. Cheers Booboo (uk
  • 4. autofilter with pictures
    I have a worksheet with pictures in one of the columns that is associated with data for that row in Excel 2002.. These pictures sort correctly with the data when I sort. However, when I use autofilter, the pictures get all jumbled up as if they're not being hidden with the rows that were filtered out. When I put the autofilter back to "all", the pictures are not in their original cells, some of them have moved to other cells. Is there a fix for this?

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