Barb...Don't know how to get back to you

[caseysmydog]

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

 

[JLGWhiz]

Let me try to explain Bob's directions.
You have formulas in cells for columns D thru I. Highlight those cell on
the row with the formulas in them by pointing the mouse to the cell in D
column and draging across to I while holding the left mouse button down.
Then you will see a
node in the lower right corner of the highlighted area. Place the mouse
pointer over that node until you see a plus sign, then press the left mouse
button and hold it while dragging the mouse pointer down the length of your
roster of names. This copies the formulas for all columns all the way down
and populates the sheet with the dates. If they do not all have the same
date joined, you might want to omit column D in the drag down.

 

[caseysmydog]

-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

 

[Barb Reinhardt]

You could put something like this in

=if(ISBLANK(A1),"",Date(year(A1),Month(A1)+3, Day(A1))

I'm guessing there's a way for you to be notified if you get a response to
your message in your newsreader. That's what you need to do so you don't
have to start multiple threads.

 

[caseysmydog]

-- Where would you put the formula you suggested?
Also, how do I get back to you so I don't start so many threads. Many thanks.
Please have patience with us.
David

 

[Barb Reinhardt]

You know the formulas you entered before. Replace them with something like
this where A1 is the cell with the Join Dates (or whatever it was)

=if(ISBLANK(A1),"",YourFormula)

And for you to get back to me, just reply to this thread. I'm notified, but
keep in mind that I can't always immediately come back to respond. There
are many others who are around and can if they have the whole thread
available.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.