Dates in Excel....

[kjonnnnn]

Is there a way to tell excel to format cells with certain dates using a certain interval? E.g. Lets say I highlight a row or column of cells, I have the first cell set to start at 1-2-00 and then excel would add and inteval of 7 for all the cell highlighted so that they would be, 1-2-00, 1-9-00, 1-16-00, 1-23-00, 1-30-00, 2-6-00,2-13-00 and so on... you get the idea.

I think I used to be able to do this in 1-2-3. [sig][/sig]

 

[dsi]

I am not sure this can be done just by highlighting the desired cells. Here are a couple of ideas.


You can use a formula.
Cell A1: 1-2-00
Cell A2: =A1+7
Then, copy and paste the formula in cell A2 to all other cells in that column.

You can also use the automatic intervals in Excel.
Cell A1: 1-2-00
Cell A2: 1-9-00
Then, highlight the 2 cells, grab the lower right corner of cell A2 (the cursor turns into a + sign) and drag over all of the desired cells in the column.


[sig][/sig]

 

[kjonnnnn]

Thanks!!!!

I'll try it. [sig][/sig]

 

[BobCrawf]

You can input the first two cells with the 7 day offset.
Then highlight both cells, grab the handle in the lower right corner and drag as far as you need.

Each cell will then have a date 7 days later than the one befor it. [sig][/sig]

 

[jennuhw]

Here is something on Microsoft I found. I am still playing with the subtraction of the dates, but it might help someone else.

http://support.microsoft.com/suppor...dates?&rnk=3&src=DHCS_MSPSS_gn_SRCH&SPR=XLW2K

 

[SimonDavis]

You can also use the 'edit/fill series' menu option, and use the 'step' option to specify the interval.