+ Reply to Thread
Results 1 to 4 of 4

Picking Dates with If/Or

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    46

    Picking Dates with If/Or

    hey guys,

    I'm having trouble writing fitting all the conditions i need into a formula. I attached a sample file. the idea is to find the letter from sheet2 on sheet1 and paste the earliest of the two dates in the cell next to it. It seems simple to test for which dates is smaller and just put that, but if a date cell is blank, i need the formula to recognize the cell is blank and not pick it. Also, if both cells are blank, I need it to return "" and not 0. I was able to the blank-check to work for 1 column via index match match and if else, but i can't figure out how to do it for both and have the "" as well.

    Any advice?

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Picking Dates with If/Or

    date chooser.xlsx
    =MIN(Sheet1!$B2:$C2)
    format as
    dd/mm/yyyy;-0;;@
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Registered User
    Join Date
    03-19-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Picking Dates with If/Or

    Very simple! needed to add index match, but got it working. Thanks!

  4. #4
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Picking Dates with If/Or

    You are welcome.

+ 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: 4
    Last Post: 04-11-2013, 02:14 PM
  2. [SOLVED] Vlookup – Picking up first date and then picking up second date if there is one.
    By CranstonWatts in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2012, 11:32 AM
  3. Picking the last non-zero value in a row
    By iccy in forum Excel General
    Replies: 3
    Last Post: 11-04-2009, 11:01 AM
  4. [SOLVED] Picking every monday from a list of dates
    By Arne Hegefors in forum Excel General
    Replies: 6
    Last Post: 08-03-2006, 11:05 AM
  5. Picking more than one name
    By Maniac in forum Excel General
    Replies: 1
    Last Post: 02-01-2005, 12:36 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