automatic dates in a column

Programming and Web Development Forums - MS EXCEL - Excel Forums for Business Finance, Analysis and Application Development

Skip to content

automatic dates in a column

MS EXCEL
Post a reply

    Sponsored Links

    Next

  • 1. average if zero
    I'm looking for a formula similar to the following, but one that works. =average(if((A1:A4="Jones")+(C1:C4>"0"),C1:C4)) Column A represent sales rep column, and I want to see the average sales for all cells that have data entered in column C. I've tried the ctrl+shift+enter, but it's still averaging with zeros, so something is wrong with my formula. Thank you. -- Lori
  • 2. How do I create a list of sequential numbers using Excel or Acces.
    I am trying to generate a list of numbers, incrementally increased to my specifications. I absolutely hate the idea of having to do these myself....is there a way to have Excel or Access generate this list for me?
  • 3. changing the color of the buttons
    Hello Everybody! Can someone tell me how to change the color of a button in a form. I am making a form and the default color of the button is grey, is there any way of changing that color? Thx,
  • 4. How do I follow a hyperlink by just pressing "enter"?
    How do I follow a hyperlink by just pressing "enter"? My 2000 version of Excel allowed me to do just that. With the 2003 version of Excel, I have to put my mouse pointer and left-click... much more cumbersome! Is ther a way that I can make the 2003 version of Excell behave more like the 2000 version in this regard? My e-mail address is XXXX@XXXXX.COM
  • 5. How can I follow a Hyper-link by just pressing "Enter"?
    How can I follow a Hyper-link by just pressing "Enter"? My 2000 version of Excel allowed me to do just that. All I would have to do to follow a Hyper-link would be to select the cell and press "Enter". Very fast! Now I have switched to the 2003 version of Excel and the first thing I notice is that I have to pick-up my mouse and left-click the Hyper-linked cell. Very slow and cumbersome! Is there a way that I can make the 2003 version of Excel behave more like the 2000 version of Excel in this regard? Bob XXXX@XXXXX.COM 4/5/05

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/
Top

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

-- 

Regards,

Peo Sjoblom
Top

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 
one???

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.

5.date column based on existing date column 

If your end date is in A1, then in B1 use:

=a1-365


"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:
>
> END DATE          START DATE
> 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

Post a reply

Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 1 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group