fixed : calculate the number of days between 2 dates

Question :

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 ?

Answer :

there are 2 formulas available to do this, choose the one that works best for you in Excel or Numbers :

formula =DUR2DAYS(enddatestartdate)+1


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 !

enjoy 😉