title: What is the equivalent of the "Days" function or number of days between 2 dates in excel 2007?
body: <p>I get the #NAME? error when I use the Days() function because the formula was built in Excel 2016 and it was probably not present in Excel 2007 yet. The error is shown:
  <a href="https://i.stack.imgur.com/UujQ1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UujQ1.png" alt="Error"></a></p>
  
  <p>Originally, the formula suddenly had a xlfn appear before the function, I do not know why so I removed it. 
  <a href="https://i.stack.imgur.com/KyHZT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KyHZT.png" alt="Original Error"></a></p>