title: Excel: Check cell for date
body: <p>Short story short:</p>
  
  <p>I want to check the cell C21 if it contains a date. I can't use VB cause it's deactivated by GPO.</p>
  
  <p>Used this from <a href="http://answers.microsoft.com/en-us/office/forum/office_2010-excel/formula-to-check-if-it-is-a-date/39c833d6-94d3-4c83-b3f6-117a5fd20344" rel="noreferrer">this page</a></p>
  
  <p><strong>D21 contains this:</strong></p>
  
  <pre><code>=WENN(ISTZAHL(DATWERT(C21));"date";"no date")
  in english
  =IF(ISNUMBER(DATEVALUE(C21))...
  </code></pre>
  
  <p><strong>C21 this:</strong></p>
  
  <pre><code>=HEUTE() # in english: =TODAY() Maybe other dates later, but allways in the correct format
  </code></pre>
  
  <p>but it allways returns "no date"</p>