title: Nested IF statements in Excel using Dates
body: <p>Ive searched far and wide on Stackoverflow, and I cannot seen to locate my question. I clearly am having an issue with the nested IF statement, but i cannot find any reference question to duplicate my situation. </p>
  
  <p>Here is what I am "trying" to do.</p>
  
  <pre><code>"Received" Cell H3 = 12/10/2017
  "Start Date" Cell I3 = 12/15/2017
  "Finish Date" Cell K3 = 12/20/2017
  </code></pre>
  
  <p>"Status" Cell J3 is where I want the following options to show up. </p>
  
  <p>If Date present in H3 (Received), show "Bare". If Date shown in I3 (Start Date) Greater/Later than H3 (Received Date), show "In Process". If Date shown in K3 (Finish Date) is Greater/Later than I3 (Start Date, then J3 should reflect "Completed". If nothing shown in H3 (Received), show Nothing in J3.</p>
  
  <p>This is the string that I am using, and it works in all aspects EXCEPT it doesn't show "Completed" when I add the "Finish Date" in. Since it works kinda, but not all the way is where I admit defeat. I need an error to chase if I am doing to diagnose with any luck lol </p>
  
  <pre><code>=IF(H3&lt;&gt;"",IF(I3&gt;H3,"IN PROCESS",IF(K3&gt;I3,"COMPLETED","BARE")))
  </code></pre>
  
  <p>ANY Help would be appreciated, im sure its probably something rather simple in regards to my eye not seeing a comma... but if im way off im eager to learn! <br>
  Thanks in advance. <br>JH</p>