LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default How to select info based on date

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum select cells based on date range Chad Excel Worksheet Functions 2 March 4th 08 06:21 PM
Select criteria based on date N85DZ Excel Discussion (Misc queries) 2 May 10th 07 03:34 AM
copying cell info from one worksheet to another based on a specific date [email protected] Excel Programming 8 November 16th 06 03:31 PM
Return info based on Date Range kermitforney Excel Worksheet Functions 3 July 11th 06 07:59 PM
Select sheet based on userform date input mugitty Excel Programming 4 January 22nd 06 09:37 PM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"