View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Barb...you helped & said come back

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" wrote in message
...
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