-It worked! Thanks,
NOW, the formula cells have dates in them because the name and date joined
have not been pu in yet. As we do, the correct dates appear. Question: Any
way to get the cells not to show a date until we input the date joined?
Again THANKS, David
David


"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

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