+ Reply to Thread
Results 1 to 3 of 3

Pull dates from multiple columns that fall into the same month/year.

  1. #1
    Registered User
    Join Date
    02-25-2007
    Location
    Helotes, Texas
    MS-Off Ver
    Excel 10
    Posts
    2

    Pull dates from multiple columns that fall into the same month/year.

    A B C D E F G H I J K L M
    Crid First Name Last Name SCT type Donor Graft Day 100 Day 180 Yr. 1 Yr. 2 Yr. 3 Yr. 4
    123 Patient A 10/10/11 Allo MUD pb 01/18/12 04/07/12 10/10/12 10/10/13 10/10/14 10/10/14
    456 Patient B 01/02/14 Auto self pb 10/30/13 01/18/14 07/22/14 07/22/15 07/22/16 07/22/16
    789 Patient C 01/25/14 Allo MSD bm 08/10/14 10/29/14 05/02/15 05/02/16 05/02/17 05/02/17
    1122 Patient D 08/14/07 Auto self pb 11/22/07 02/10/08 08/14/08 08/14/09 08/14/10 08/14/10
    1455 Patient E 09/16/14 Allo MSD pb 12/25/14 03/15/15 09/16/15 09/16/16 09/16/17 09/16/17
    1788 Patient F 11/25/13 Allo unrelated cord 03/05/14 05/24/14 11/25/14 11/25/15 11/25/16 11/25/16
    2121 Patient G 08/27/13 Allo unrelated cord 10/23/14 01/11/15 07/15/15 07/15/16 07/15/17 07/15/17
    2454 Patient H 01/31/08 Auto self pb 05/10/08 07/29/08 01/31/09 01/31/10 01/31/11 01/31/11
    2787 Patient I 03/30/14 Allo MUD pb 07/08/14 09/26/14 03/30/15 03/30/16 03/30/17 03/30/17
    3120 Patient J 11/30/06 Auto self pb 03/10/07 05/29/07 11/30/07 11/30/08 11/30/09 11/30/09
    3453 Patient K 11/01/07 Auto self pb 02/09/08 04/29/08 11/01/08 11/01/09 11/01/10 11/01/10
    7890 Patient L 07/12/14 Allo unrelated cord 06/08/14 08/27/14 02/28/15 02/28/16 02/28/17 02/28/17

    Data in columns B through G is retrieved from a master list by VLOOKUP function with comparison values located in column A
    Dates in columns H through M auto-populate by formula based on source dates in column D.

    I need to know
    1.) which reports become due during the same month/year for all dates and
    2.) which reports become due during the same month/year >=TODAY()

    The output should look like this example for October 2014:

    A B C D E F G H I J K L M
    ID First Name Last Name SCT type Donor Graft Day 100 Day 180 Yr. 1 Yr. 2 Yr. 3 Yr. 4
    123 Patient A 10/10/11 Allo MUD pb 10/10/14
    7890 Patient L 07/15/14 Allo unrelated cord 10/23/14
    456 Patient B 05/02/14 Allo MSD bm 10/29/14
    236 Patient G 07/22/13 Auto self pb 10/30/13
    etc. etc. etc.

    Can this be done?

    Thanks in advance for helping this Excel 10 Novice.
    Attached Files Attached Files
    Last edited by safrau; 10-23-2014 at 04:38 AM.

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Pull dates from multiple columns that fall into the same month/year.

    Hi, Refer the attachment with formulas
    Attached Files Attached Files
    Click just below left if it helps, Booşathì

  3. #3
    Registered User
    Join Date
    02-25-2007
    Location
    Helotes, Texas
    MS-Off Ver
    Excel 10
    Posts
    2

    Re: Pull dates from multiple columns that fall into the same month/year.

    Thanks a Million, boopathiraja, I am very impressed with your solution. This works perfectly to identify which patients are due for their pre-determined visit date in a given month. Can Excel by any chance auto-populate only those rows (A1:G267) that return a result and not show rows with blank results? In other words, if Excel finds a date in any of columns H:M, can Excel pull the related Data residing in the same row in columns A:G from the range in the data worksheet? I am only familiar with using a filter which would involve extra steps.
    Sorry about the terrible jargon. I have not passed the Excel dummy stage, as you can tell.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 22
    Last Post: 11-20-2012, 02:44 AM
  2. Replies: 4
    Last Post: 01-20-2010, 10:10 AM
  3. Replies: 2
    Last Post: 07-12-2009, 04:52 PM
  4. Replies: 7
    Last Post: 04-23-2009, 07:02 PM
  5. Replies: 1
    Last Post: 04-23-2009, 05:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1