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

I did not understand Bob's help & could not find your other thread.
Above is how the message should have looked. Where do you put the formula
for each cell? In the formula bar, or the cell itself?
When I tried to do what Bob suggested I got a date in column 2.
Many thanks for helping---we are lost.
David

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.
Than
--
David