C
caseysmydog
You helped us get this far...
Now, here's the story:
Our Excel list is about 125 people long. Each row has the person's last
name, first and date joined, xx/xx/xx. The program then calculates dates for
ea person as follows: 1 moth (from date joined), 3 months, 6 months, 9
months, 12 months and puts that in each cell across the row.
Name Date joined 1month 3 months 6months 9months
12months
Smith, Sam 10/12/08 11/12/08 1/12/09 etc etc
etc
Smith, Jane 09/14/08 10/14/08 12/14/08 etc etc
etc
-------------------------------------------------------------------------------
Smith, Sam 10/12/08 11/12/08
Here's what we hope we can do: Process the same data and have it list for ea
column person's who meet that column's criteria, 1e, is it one month from
date joined, then list name and joined date. Is it three months since date
joined, then list name date and joined date...and so on looking through
joined date till each person is scanned and those who meet formula are
listed.
Is it possible to do this?
Thanks very much...would be glad to clarify if we were not clear or would
love to hear if you have a better way.
David
Now, here's the story:
Our Excel list is about 125 people long. Each row has the person's last
name, first and date joined, xx/xx/xx. The program then calculates dates for
ea person as follows: 1 moth (from date joined), 3 months, 6 months, 9
months, 12 months and puts that in each cell across the row.
Name Date joined 1month 3 months 6months 9months
12months
Smith, Sam 10/12/08 11/12/08 1/12/09 etc etc
etc
Smith, Jane 09/14/08 10/14/08 12/14/08 etc etc
etc
-------------------------------------------------------------------------------
Smith, Sam 10/12/08 11/12/08
Here's what we hope we can do: Process the same data and have it list for ea
column person's who meet that column's criteria, 1e, is it one month from
date joined, then list name and joined date. Is it three months since date
joined, then list name date and joined date...and so on looking through
joined date till each person is scanned and those who meet formula are
listed.
Is it possible to do this?
Thanks very much...would be glad to clarify if we were not clear or would
love to hear if you have a better way.
David