automatic dates in a column


    Sponsored Links


  • 1. Import Email from Outlook into Worksheet
    Hi, I have to import emails from Outlook into an excel worksheet. I need to import the full email (and any attachments). Currently I copy the email to my desktop as a .msg file, then insert object, create from file and display as icon. Does anyone know a quicker way then this - it's driving me nuts!! Thanks for any help Regards Cillian -- Cillian
  • 2. Trivial question
    Hi! I know this is a very trivial question but I have not been able to find the answer anywhere I have an excel sheet featuring a row (row 1) with the following sequence of numbers: CELL A1 B1 C1 D1 E1 F1 G1 VALUE: 1 2 3 4 5 6 7 I want to arrange these numbers vertically , something like this CELL VALUE L1 1 L2 2 L3 3 L4 4 L5 5 L6 6 L7 7 Which is the formula I should insert into cell L1 and drag along L column to accomplish this? Thanks for your support
  • 3. Function to clear data
    Please help me figure this out: If I have the months in column A such as: 04/05 05/05 06/05 and so on and other data in column B I would like to create a formula where if I enter in a cell 05/05 then it would clear all the content in column B for the month of 05/05 and all the months before this. Thank you so much. Renee
  • 4. copy cell value not contents
    i enter 69.5 in a cell. The i format the cell so there is no decimal places and the value in the cell is now 70. Now i copy this cell to another one and paste special - select value. Now it pasts 70 into the new cell but i want to get rid of the 69.5 in the formula bar accross the top. Is there any way i can do this ? I know you can do it if you have a formula and just want to copy the value. Don't see where you can do it in this case. Someone please help. Is this a bug in Excel ?
  • 5. Input Mask for Dates
    Can I apply an input mask or custom format to cells so that users do not have to type the slashes for date entry? 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 92 guest