title: How to check if a date cell in Excel is empty?
body: <p>If feels like this should be really easy but I dont get it to work without retrieving the value of the cell again.</p>
  
  <p>To start with, I have 2 date cells:</p>
  
  <pre><code>Dim agreedDate As Date
  Dim completedDate As Date
  </code></pre>
  
  <p>THIS WORKS .. (but looks messy)</p>
  
  <pre><code>agreedDate = Worksheets("Data").Cells(Counter, 7).Value
  completedDate = Worksheets("Data").Cells(Counter, 9).Value
  
  If (IsEmpty(Worksheets("Data").Cells(Counter, 7).Value) = True) Or (IsEmpty(Worksheets("Data").Cells(Counter, 9).Value) = True) Then
  
  [.. do stuff]
  End If
  </code></pre>
  
  <p>THIS DOES NOT WORK - WHY NOT?! </p>
  
  <pre><code>agreedDate = Worksheets("Data").Cells(Counter, 7).Value
  completedDate = Worksheets("Data").Cells(Counter, 9).Value
  
  If (IsEmpty(agreedDate) = True) Or IsEmpty(completedDate) = True) Then
  
  [.. do stuff]
  End If
  </code></pre>
  
  <p>Is there a way to write the if statement in a clean and easy way?</p>