Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum select cells based on date range | Excel Worksheet Functions | |||
Select criteria based on date | Excel Discussion (Misc queries) | |||
copying cell info from one worksheet to another based on a specific date | Excel Programming | |||
Return info based on Date Range | Excel Worksheet Functions | |||
Select sheet based on userform date input | Excel Programming |