Consulting

Results 1 to 2 of 2

Thread: Date Lookup Problem

  1. #1
    VBAX Regular
    Joined
    Jan 2018
    Location
    Nova Scotia
    Posts
    83
    Location

    Date Lookup Problem

    Hi All,
    I need your help with a formula to check dates and input a status in a cell. I want the formula to do the following:
    1.) If there is a checkmark in the range D4:I4, AND
    2.) If the corresponding date in range D2:I2, is greater than today's date, THEN
    3.) Cell J4 = "Behind Schedule"

    I'd like this formula in each cell for column J compared to the date range in D2:I2. I attached the sample spreadsheet.

    I'm thinking this is an if statement with an Index and Match formula, .....or a sumproduct formula but I'm stuck.

    Any help would be appreciated.
    Thanks,
    Jim
    Attached Files Attached Files

  2. #2
    VBAX Regular
    Joined
    Jan 2018
    Location
    Nova Scotia
    Posts
    83
    Location
    I figured it out

    =IF((INDEX(DueDate,MATCH("ü",D4:I4,0)))< NOW(), "Behind Schedule", "On Track")

Posting Permissions

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