Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Barb...Don't know how to get back to you
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Barb...Don't know how to get back to you
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" 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Barb...Don't know how to get back to you
-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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Barb...Don't know how to get back to you
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. -- HTH, Barb Reinhardt "caseysmydog" wrote: -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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Barb...Don't know how to get back to you
-- 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" wrote: 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. -- HTH, Barb Reinhardt "caseysmydog" wrote: -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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Barb...Don't know how to get back to you
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. "caseysmydog" wrote: -- 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" wrote: 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. -- HTH, Barb Reinhardt "caseysmydog" wrote: -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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Barb...you helped & said come back | Excel Programming | |||
Attn: Barb Reinhardt | Excel Programming | |||
Barb - don't worry, I got it working...you are a lifesaver!!!!!!.t | Excel Programming | |||
for Toppers and Barb | Excel Worksheet Functions | |||
Barb Reinhardt: HOW TO: Plot a Team Name .... | Charts and Charting in Excel |