automatic dates in a column


    Sponsored Links


  • 1. switch off transforming number into date
    How do I switch off that autocomplete or autoformat or whatever the name of that feature, which transform a decimal number like 12.42 into marcian-looking date like Dec.42 ? It does it at random in some cells
  • 2. Adding hours
    Hi, I am having a difficult time adding up the total number o hours/minutes. I understand that going over 24 hours means you need t format the cell [hh]:mm but in doing so I get close to the actual tota but am still off by 11 minutes. Here is an example: 4:51, 5:23, 4:59 6:53, 7:43, 6:31 and 6:57 When I total manually, I come up with 43:29 (or 43:28 depending o where your decimal is on your caculator). When I formatted the "tota amt" cell to [h]:mm, the number of hours/min came to 43:17. When tried using Excel's Help, they advised to use this formula: =SUM(A2:A8)*24 but all that did was change the total sum to 0. M husband and I have spent hours trying to figure this out so any hel would be greatly appreciated. Thank you
  • 3. filter for missing values in a range
    I have a list in Col A ( about 2000) one to four digit numbers. I would like to ( for example) , in the 700's be able to filter and find out which of the numbers from 700 to 799 is NOT in the list. I know how to copy and paste to another col, etc. Thanks in advance for the wonderful help all of you give.
  • 4. i want excel to show the first tab upon opening, not the secon
    Hmm, Actually no I intended to write sheets(2) but that's because I misread the post!! Thanks for the correction. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. " () " wrote: > I assume mikes intention was to type: Sheets(1) > Beside that - if you'll save your WB while sheet(1) is in focus - that sheet > will be shown the next time you open that WB. > Micky > > > > "robsc" wrote: > > > > > when i open my spreadsheet, it always opens with the second sheet prominent, > > rather than the first. how can i change this?
  • 5. i want excel to show the first tab upon opening, not the second
    when i open my spreadsheet, it always opens with the second sheet prominent, rather than the first. how can i change 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 44 guest