title: Excel proper date format in Excel
body: <p>I have worksheet named as <code>Correlation_Process</code> and it contains the field of <code>Birthdate</code> and <code>Age</code>.</p>
  
  <p>what i want to do is to get the age based on the birthdate i already get the age based on the birthdate using excel formula. but some of the rows returns some error like this #VALUE!</p>
  
  <p>Here's my excel formula to get the age: =DATEDIF(A:A,NOW(),"y")
  and Here's my date format (Month/day/year) i dont get the error shown in picture which is <code>#VALUE!</code> when some of the rows are showing the expected output
  anyone can help?</p>
  
  <pre><code>=DATEDIF(A:A,NOW(),"y")
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/eeQSv.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eeQSv.jpg" alt="enter image description here"></a></p>