title: How to delay a formula to be shown for a certain number of hours?
body: <p>I'm using Excel 2013. In cell D5 I have my date of birth, in cell E5 I have a formula that recognizes if today is my birthday and if it is, it shows <code>YES</code>, if not <code>NO</code>. Now the formula works great BUT the formula MUST NOT show <code>YES</code> before 10 a.m.!</p>
  
  <p>How can I delay that formula so it only shows <code>YES</code> if it's past 10am?</p>
  
  <p>I'm not doing this in VBA because I've got a task to write a formula! Here's the formula:</p>
  
  <pre><code>=IF(TEXT(D5;"d.m.")=TEXT(TODAY();"d.m.");"YES";"NO")
  </code></pre>
  
  <p>Please can someone write me the delayed formula or tell me what function I should use to delay that formula?</p>