Barb...
Works great!
Now here's what this looks like & a question.
abc D E F G H
I
1 Name Joined 6 weeks 3 mths 6 mths 9 mths 13 mths
2
3Watson 2/4/08 3/17/08 5/4/08 8/4/08 11/4/08 3/4/09

Question: we will have about 200 entries. Do I have to manually enter the
formulas changing D progressively each time. That would be 5 formulas across
for each line (entry/person)

Then, we can address how to pull information and sort.
Thanks,
David
--
David

No just enter them in row 2, select D2:H2, move the cursor to the bottom
tight hand cell until it changes to a black cross, then just drag the
formula down.

--
__________________________________
HTH

Bob

"caseysmydog" <(E-Mail Removed)> wrote in message
news:1BCECBD2-9DF2-45CD-AA97-(E-Mail Removed)...
> Barb...
> Works great!
> Now here's what this looks like & a question.
> abc D E F G H
> I
> 1 Name Joined 6 weeks 3 mths 6 mths 9 mths 13 mths
> 2
> 3Watson 2/4/08 3/17/08 5/4/08 8/4/08 11/4/08 3/4/09
>
> Question: we will have about 200 entries. Do I have to manually enter the
> formulas changing D progressively each time. That would be 5 formulas
> across
> for each line (entry/person)
>
> Then, we can address how to pull information and sort.
> Thanks,
> David
> --
> David

I saw your replly, but this is the first I've had time to come back. I just
answered your message in the other thread and I see Bob has answered it here.


Barb Reinhardt

"caseysmydog" wrote:

> Barb...
> Works great!
> Now here's what this looks like & a question.
> abc D E F G H
> I
> 1 Name Joined 6 weeks 3 mths 6 mths 9 mths 13 mths
> 2
> 3Watson 2/4/08 3/17/08 5/4/08 8/4/08 11/4/08 3/4/09
>
> Question: we will have about 200 entries. Do I have to manually enter the
> formulas changing D progressively each time. That would be 5 formulas across
> for each line (entry/person)
>
> Then, we can address how to pull information and sort.
> Thanks,
> David
> --
> David