I want to integrate a formula in my spreadsheet (in Excel or Numbers) that calculates the number of days between 2 dates that I have in other cells on the spreadsheet.
How do I do that ?
there are 2 formulas available to do this, choose the one that works best for you in Excel or Numbers :
formula =DATEDIF(startdate, enddate, “D”)+1
NOTE : the “+1” in both these formulas is only needed if you want the number of days including both startdate and enddate !
That’s it !