Most valuable professional
  • Hot Topics

Excel Count - index - match problem

Hey Chaps I am basically trying to retrieve a date in column F with specific conditions. Basically I want to get the result (DATE) from after the DATE in cell E6 and E7. E.g Therefore CELL F6 should show 03/12/2012 because CELL E6 has the date of 26/11/2012 (<--- Hence M5[Date] Onwards). And F6 should show 06/11/2012 but instead shows 01/11/2012. My current formula pulls the very first date but what I want is the value/date onwards from cell E6-E7. REALLY SORRY ABOUT THE PICTURE ... I can't install HTML Genie at work so had to upload a photo! [IMG]Image and video hosting by TinyPic[/IMG] Again! SUPER APPRECIATIVE FOR ANY HELP OR GUIDANCE! Will donate to charity for your choice for your help! Kind regards Syed from England Last edited by syedbokhari; Apr 2nd, 2014 at 08:46 AM.

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of April 2, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel