Date started and finished question?

[Buzz Local#30]

Is there a solution to this question
if I started work say on 1/1/08 and finished the job on 2/1/08
Can I have this automated to say dates 1/1/08 thru 2/1/08

I have a cell that I can enter in a date I started and I think I can have
several other cell automatical enter in the date a week later in each cell a
week difference from each cell by using say the start date cell is called
A2+7 and we'll say this sum is entered in A4 Could I in A5 use this formular
A4+7 and so on for however many weeks it takes.
Well actualy that was 2 question lol sorry if I confused anyone there
So if I can count each of those cells and have the result be 1/1/08 thru
2/1/08 how do I do it?

 

[Bob Phillips]

=TEXT(A2,"m/d/yy -
")&TEXT(INDEX(A2:A20,MAX(IF(A2:A20<>"",ROW(A2:A20)-ROW(A2)+1))),"m/d/yy")

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Buzz Local#30]

Not sure I follow you here I tried to put this in a blank page just to try
and follow it but couldnt?