title: Number of days between past date and current date in Google spreadsheet
body: <p>I want to calculate the number of days passed between past date and a current date. My past date is in the format <code>dd/mm/yyyy</code> format. I have used below mentioned formulas but giving the proper output.</p>
  
  <pre><code>=DAYS360(A2,TODAY())
  =MINUS(D2,TODAY())
  </code></pre>
  
  <p>In the above formula <code>A2</code> = <code>4/12/2012</code> (dd/mm/yyyy) and I am not sure whether TODAY returns in <code>dd/mm/yyyy</code> format or not. I have tried using 123 button on the tool bar, but no luck.</p>