automatic dates in a column


    Sponsored Links


  • 1. How do I save the same document in 2 different files
    I save my budget document during each use. In Excel 2003 I was able to save it once a week to a 2nd 'safety' file as well. Now with 2007 there is no 'save as' (at least not that I can find) so am not able to save a 2nd copy for safety. It's a very different program and I realize I have to get use to the changes. Can anyone help?
  • 2. Compatibility Checker - minor loss of fidelity
    I am running Excel 2007 on Windows 7. I have a template (MyFile.xlt), and when I try to save a new workbook (Excel 97-2003) based on the template, the compatibility checker pops up. I have tracked the issue to some cell coloration that I applied to one sheet. If I change the cells to no color, then it saves without compatibility issues. I have colored cells many times in the past with Excel2003 with no issues - why is there a problem with it now? Thanks for any advice, ~ Horatio
  • 3. Error when Saving a Workspace
    When I try to save a workspace I get an error message that says "The extension can not be used with the selected file type. Change the file extension in the file name text box or select a different file type by changing the save as type". I have tried these suggestions but it doesn't work. The only file type available is "workspace". This works fine on my laptop but will not save on my desktop. Any suggestions? -- PVdof
  • 4. Data summary
    I trying to sort out a small spreadsheet for a charities collections and want to keep as simple as possible as the users are novices. They are using Excel 2000. I set up a sheet that worked, but of necessity contained 26 columns ( one for each collectors takings) spread over 200 rows (Theoretically 366 max). In practical terms it wasn't user friendly. In essence it would be better to need only to enter a date, a name and a sum of money in 3 columns and have totals calculated in secondary sheets. My guess is that in order to get meaningful monthly totals against each of the 26 collectors will require some VBA code to pull that data into separate sheet. Can anyone guide me on data manipulation. I need to identify all instances of each of the names and total each name's takings for each calender month. thanks Pete
  • 5. drop down list should remember selection.
    Hi, I have list on names on my first sheet in A column, on sheet2 i have list of products with names. How can i create drop-down list for each name, so that i can select items from the list from second sheet, also drop-down list should remember maded selection for each name. Is it possible? Thank you in advance. Peter

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