software

OKay here is what I have. I have a drawing log for a construction site that I
am trying to create. Now, we regularly get revisions to the drawings and they
have to be tracked. Right now we are up to revision 5.

So, in cell D46 I have a validated list of all the dates that we received
the revisions. In cells G46 through N46 there are blanks for each revision.
What my boss wants is if 10/19/2004 corresponds to revision 4 he wants G46 to
show quot;0quot;, H46 to show quot;1quot;, I46 to show quot;2quot; etc.

I have two columns off to the side one has the date and the adjancent has
the corresponding revision number. I have named this list REV_DATES.

Is there a way so that if I enter 10/19/2004 in D46 that cells G46 through
K46 will show 0, 1, 2, 3, 4 respectively?

Is this enough info? I can email the sheet if neededThanks
NeilM

Hey Neil,

I wouldlike to look at your problem.
You can send the sheet to
--
Jeroen van Nieuwkerk

quot;Neil Mquot; wrote:

gt; OKay here is what I have. I have a drawing log for a construction site that I
gt; am trying to create. Now, we regularly get revisions to the drawings and they
gt; have to be tracked. Right now we are up to revision 5.
gt;
gt; So, in cell D46 I have a validated list of all the dates that we received
gt; the revisions. In cells G46 through N46 there are blanks for each revision.
gt; What my boss wants is if 10/19/2004 corresponds to revision 4 he wants G46 to
gt; show quot;0quot;, H46 to show quot;1quot;, I46 to show quot;2quot; etc.
gt;
gt; I have two columns off to the side one has the date and the adjancent has
gt; the corresponding revision number. I have named this list REV_DATES.
gt;
gt; Is there a way so that if I enter 10/19/2004 in D46 that cells G46 through
gt; K46 will show 0, 1, 2, 3, 4 respectively?
gt;
gt; Is this enough info? I can email the sheet if needed
gt;
gt;
gt; Thanks
gt; NeilM

Thanks much! It's on its way to you.

Anymore suggestions are still welcome.NeilM