automatic dates in a column


    Sponsored Links


  • 1. "Link to other data source" - How can I find out what is linke
    Thanks for the response... I'm using 2002. I've been to the "Links" menu and I can see the link, but when I select it, "Break Link" is not available (grayed out). The only available options are to "Open Source" and "Check Status". There's also a "Startup Prompt" button that will allow me to set it to not prompt and not update the link.... but I'd really like to find the link and fix it properly to avoid future problems. Any other suggestions? "rahrah3a" wrote: > what version of Excel are you using? If 2003, you can select Edit - Links to > view all linked documents associated with the one you are viewing. You can > select a linked document and click the "Break Links" button to remove the > link. This will replace any cell linked to another document with it's value. > > "Chicago D" wrote: > > > When I open my workbook, I get a message asking if I want to update the links > > to other data sources but I can't find any formulas that reference another > > workbook! > > > > I copied a sheet from another workbook into this workbook and thought I > > updated all formulas, but obviously I missed one and can't seem to find it. > > Any suggestions for quickly finding the formula that's causing this?
  • 2. how do i sort a col of formulas in excel
    i have a col of totals in the form of formulas. i want to sort this col but somehow i need to freeze the results of the formulas first.
  • 3. It's Gone!
    A co-worker somehow destroyed an important excel spreadsheet and wants me to do the impossible. The file is completely blank. The system is running Windows 98 and Office 97. The file was stored on a network drive (M:). I checked the dates for the file: Created on 8/19/2005 4:33 PM, Last Saved on 8/19/2005 4:44 PM. And last edited on her computer. Well, that sorta speeks for itself. I don't think there is any hope, but maybe you know of a temporary directory to hold files when an Office program opens a file, or in the Windows or user directories... And maybe not. I'm thinking we need to chalk this one up as a loss. Thanks, Nick
  • 4. How do I setup a header in Excel that prints only on first page?
    I've created an Excel spreadsheet with a header. The spreadsheet prints on 5 pages. I want the header to print on pg 1 but not pgs 2-5. Is this possible? Currently the header is a custom header and prints on every page. I'd prefer fot he header to print on pg 1 only.....
  • 5. allow users to edit a range in excel 2000
    I am creating a spreadsheet for users using Excel 2000 and I would like to protect the worksheet and still allow users to edit a range of cells in the worksheet. By just applying a password to the worksheet I would have to rely on the other users remembering to put the password back on again once they had finished entering their data. I know that this facility is available in later versions of Excel and I was wondering if there was a way to replicate it in Excel 2000.

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