+ Reply to Thread
Results 1 to 9 of 9

Compare Dates To Date Range & Return Date Based On Outcome

  1. #1
    Registered User
    Join Date
    07-02-2008
    Location
    S.D.
    Posts
    4

    Compare Dates To Date Range & Return Date Based On Outcome

    Ok
    Just to make sure everyone knows. I have been searching Array comparison, vlookup and if statements.
    But I can't seem to find anything to help me out.

    My problem is that I need to compare three cells of random dates shown in Column E, F,& G with Row's H5:AK5, H7:AK7, H9:AK7 (the Dates to these rows is Static on row H3:AK3.)
    EX: ROW 5 has Start Date, End Date (1) and End Date (2). Compare Cell H3 between Start Date & End Date (1). If H3 falls between or equal to Start and End Date(1) then highlight cell H5. Proceed till AK3 (higlighting only the cells H5:AK5). Then compare cell H3 between or equal to End Date (1) and End Date (2) (higlighting only the cells H5:AK5)

    Then do the same for ROW 7 and ROW 9.

    To make things a bit more difficult I need to have " WK#" in Row 14 (these WK# is on another tab called "Task" of the workbook) needs to be displayed in Row's H4:AK4, H6:AK6, & H8:AK8.
    EX: Compare Date in D15 between or equal to Start Date & End Date (1) then display Wk# in D14 in H4. Continue till all dates in
    D15:Z15 are compared to Start Date & End Date (1) and WK#'s in Row D14:Z14 are inputted if applicable
    in Row H4:AK4, H6:AK6, H8:AK8.
    I hope this is not confusing.

    I can't seem to use the upload option so here is alink to download a jpg of the sheet. I hope it will be readable.

    http://i23.photobucket.com/albums/b3...oya/sample.jpg


    email: gus.montoya@gmail.com
    Attached Files Attached Files

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,663
    "This image has been deleted or removed"

    Zip and post your workbook, max 100K.

  3. #3
    Registered User
    Join Date
    07-02-2008
    Location
    S.D.
    Posts
    4

    Adding file

    THis is the file I am working on.
    Attached Files Attached Files

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,663
    Compare Cell H3 between Start Date & End Date (1). If H3 falls between or equal to Start and End Date(1) then highlight cell H5. Proceed till AK3 (higlighting only the cells H5:AK5). Then compare cell H3 between or equal to End Date (1) and End Date (2) (higlighting only the cells H5:AK5)
    So is the cell to be highlighted if row 3 is between start and end1 dates, or between end1 and end2 dates, or ???

  5. #5
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,663
    Cross-posted at http://www.xtremevbtalk.com/showthread.php?t=298285

    gusmontoya, please read our Forum Rules.

  6. #6
    Registered User
    Join Date
    07-02-2008
    Location
    S.D.
    Posts
    4
    Quote Originally Posted by shg
    So is the cell to be highlighted if row 3 is between start and end1 dates, or between end1 and end2 dates, or ???

    That would be Start and end 1

  7. #7
    Registered User
    Join Date
    07-02-2008
    Location
    S.D.
    Posts
    4
    Quote Originally Posted by shg
    Cross-posted at http://www.xtremevbtalk.com/showthread.php?t=298285

    gusmontoya, please read our Forum Rules.
    sorry

    I am trying to get help for this. I did not read all the rules since they are so many. But I really need help on this to the point that I will pay someone for the answer.
    please help.
    Gus

  8. #8
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,663
    I did not read all the rules since they are so many.
    It will take less time for you to read the rules than it will for me or someone else to help with this.

    How about you read the rules and post back if you agree, while I look at your spreadsheet?

  9. #9
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,663
    Hey, Gus,

    If you come back, I sorted the conditional formatting, but the other thing isn't clear.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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