automatic dates in a column


    Sponsored Links


  • 1. How do I locate duplicate records in Excel?
    I'm trying to locate duplicate records in my spreadsheet. It has 15 columns and almost 3000 rows. Row B is Last Name and Row C is First Name. I need to highlight any records that have the same last and first names. So if there are multiple Bob Jones I want to check and see if they are the same person. How do I do this? I've tried all kinds of methods suggested on the web and have not been able to find a solution. Thanks!
  • 2. Newbie Help. Is this possible?
    Hello, I am just getting into Excel and would like some help very much. I a basically trying to make a spreadsheet for a restuarant that woul specify how many servers would be the floor and their sidework and tha ties into the server schedule. Problem is that different nights have different number of servers on. So my question is? Do I need to make spreadsheet for all the varients of servers (say 4-10 servers) or i there some way I can input a number like 6 and the spreadsheet wil modify itself automatically? Thanks so much
  • 3. Record information is on two lines
    I have an EXCEL SS with information as follows; Record 1: A1, B1, C1, D1, A2, B2, C2 Record 2: A3, B3, C3, D3, A4, B4, C4 I would like to fix so each record is on one line: Record 1: A1, B1, C1, D1, E1, F1, G1 etc..... Thanks for any help!
  • 4. Conditional Pictures
    How can I change a picture that is displayed in excel depending on confition?? I.e. if a cell value is one I want to display a picture o an apple next to it - if it is 2 I want to display a picture of a orange next to it (simplified example obviously!!). I know that I ca do this with a macro - but I want the picture to change automaticall as the cell value changes without having to start a macro. Any help would be appreciated!! Thank
  • 5. How do I see a .ESP image (logo) that is inserted in a worksheet?
    Our printer has sent me a excel file that contains an image (our logo) that has the extension .esp. I can see the outline, but not the actual image. When you print the worksheet it prints correctly, but you cannot see the actual image on the screen or using preview. Any suggestions?

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