automatic dates in a column

MS EXCEL

    Sponsored Links

    Next

  • 1. How do stop Excel changing column widths when doing pivots?
    When I am doing multiple pivots I have to keep resizing the columns as Excel resizes them, can autofit be turned off?
  • 2. In a spreadsheet when I create a link the default path is wrong
    When I create a link I want it to automatically go to \\mycpu\folders\other, but it goes to \\mycpu\folders\same so I have to click the up dir once then double click on the folder I want. These directories are on a network. I have gone to file, properties and set the default there for my template, that didn't work. Thank you.
  • 3. INDEX - MATCH - VLOOKUP - returning missing reference
    I am searching for a value from one table to another. The value has two identifiers that form a unique combination (in columns A and E). If the value in Sheet2 has no corresponding value in Sheet1 (meaning that the columns A and E in Sheet2 had no match in Sheet1), the value is to be returned to the cell. If the value IS in Sheet2, I want to compare the values, and if the two values are different, I want to return the value in Sheet2 to the cell. The formula seen below is what I have been using (in Sheet3) for row # 6. =IF(ISERROR(INDEX(Sheet2!B$2:B$9000,MATCH(1,(Sheet1!$A$2:$A$9000=Sheet2!$A6)*(Sheet1!$E$2:$E$9000=Sheet2!$E6),0))), "", IF(INDEX(Sheet2!B$2:B$9000,MATCH(1,(Sheet1!$A$2:$A$9000=Sheet2!$A6)*(Sheet1!$E$2:$E$9000=Sheet2!$E6),0)) = INDEX(Sheet1!B$2:B$9000,MATCH(1,(Sheet2!$A$2:$A$9000=Sheet1!$A6)*(Sheet2!$E$2:$E$9000=Sheet1!$E6),0)), "", INDEX(Sheet2!B$2:B$9000,MATCH(1,(Sheet1!$A$2:$A$9000=Sheet2!$A6)*(Sheet1!$E$2:$E$9000=Sheet2!$E6),0)))) But, if the value that im searching for is deleted in Sheet2, i get an #N/A. Shouldnt this formula just skip a deleted row and go to the next? (the row is completely deleted....it is not a blank row) thanks in advance for the help....it will be much appreciated!
  • 4. VLOOKUP - returning the searched for value if it does not exist
    I am searching for a value from one table to another (the value is located in Column A in Sheet2 and column H in Sheet1). The formula seen below is what I have been using (in Sheet3) =IF(ISNA(VLOOKUP(Sheet2!A2,Sheet1!$H$2:$H$9000,1,FALSE)),IF(BTypesInputTable!A2 = "","",BTypesInputTable!A2),"") the IF statement will convert a null value to a blank space instead of a zero. But, if the value that im searching for is deleted in Sheet2, i get an #N/A. Shouldnt this formula just skip a deleted row and go to the next? (the row is completely deleted....it is not a blank row) here is what the formula looks like after i try to search for that missing value: =IF(ISNA(VLOOKUP(Sheet2!#REF!,Sheet1!$H$2:$H$9000,1,FALSE)),IF(Sheet2!#REF! = "", "", Sheet2!#REF!),"") excel places that #REF! in my formula if the value USED to exist and then does not anymore. any ideas on how to fix this? thanks in advance!
  • 5. How to link to a single wksheet in a wkbook that has comments
    I need to create a link to a single worksheet that contains comments and resides in a workbook that has many worksheets in it.

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

-- 

Regards,

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



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 26 guest