title: In Excel, how do I calculate days between two dates ignoring full years?
body: <p>How do I calculate relative years + days between two dates in excel?  I want to know the number of years and any additional days (outside of the full years).  Dividing the total days by 365 doesn't work because of leap years.  For example:</p>
  
  <pre><code>Cell A1 = '1/31/2015'
  Cell B1 = '2/1/2025'
  Cell C1 = '2/11/2025'
  =(B1-A1)/365   # 10.0109 = 10 years + 4 days, looking for 10 years + 0 days
  =(C1-A1)/365   # 10.0383 = 10 years + 14 days, looking for 10 years + 10 days
  </code></pre>
  
  <p>Is there an easy way to calculate this?</p>
  
  <p>Note - this question is not a duplicate of <a href="https://stackoverflow.com/questions/8221148/difference-between-dates-vba">How to find the difference between dates in VBA</a> -- which is a question about calculating the difference between dates.  This question is asking how to calculate the difference of both years and days, such that the difference in days is for the final year only, and are not incorrectly including leap year days for previous years.</p>