Date started and finished question?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Buzz Local#30 - 30 Apr 2008 17:36 GMT

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?

Reply to this Message

Bob Phillips - 30 Apr 2008 17:55 GMT

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

Signature

HTH

Bob

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

> Is there a solution to this question
> if I started work say on 1/1/08 and finished the job on 2/1/08
[quoted text clipped - 8 lines]
> 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?

Reply to this Message

Buzz Local#30 - 30 Apr 2008 23:58 GMT

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

> =TEXT(A2,"m/d/yy -
> ")&TEXT(INDEX(A2:A20,MAX(IF(A2:A20<>"",ROW(A2:A20)-ROW(A2)+1))),"m/d/yy")
[quoted text clipped - 17 lines]
>> 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?

Reply to this Message

Rate this thread: