Excel Formula Help-Creating consecutive days of the week.?

Question

I am having trouble coming up with the formula I need to make my days of the week change when I change the first one. I have done the auto fill but that is not what I need. I need to be able to have the other days change. For instance, when I change, 9/24/2006, then 9/25/2006 will not change. I am just working with a 7 day a week schedule and just need a simple formula for making the rest of the days change consecutively. 10 points will be awarded for the best answer!!!

Answer 1

Lest's say cell A1 contains the date 9/24/2006. Then, if you type this formula:

= A1 + 1

into any other cell, let's say, A2, it will return 9/25/2006. Then you can copy cell A2 and paste it to cells A3 through A7; this will give you an entire week. When you replace 9/24/2006 with another date, the spreadsheet will recalculate for the new date.

Answer 2

Excel Day Of The Week

Answer 3

1.click the cell where you wish to start. say A1
2. Enter any date and press enter. Excel will recognise it as a date and automatically change its formatting as date format. If it doesn't , press ctl+1 to open Format Cell window. Select the desired date format.
3. Click the cell where you wish to have next week day (say A2)
4. Enter formula as =A1+1
Change the reference if necessary.
5. Repeat it for other cell. This time enter formula as =[prev cell ref] +1
i.e. =A2+1
6. Repeat it for remaining cells.
You can also copy and paste the formula

Answer 4

Simple. Enter the beginning date in the first cell. Then in the second cell put in the formula...+cell#+1...so if the date is in cell C6, it's +C6+1...Then copy the formula to the next five cells.