Please enable JavaScript to view the comments powered by Disqus.


(...INT(...B5)-INT(...B4))

How to calculate number of days between two dates

The formula uses the fact the day count between two dates is the arithmetic difference between the two dates. INT() part here removes the decimal portion from the dates. 


Used Functions

Category: Math and trigonometry

Rounds a number down to the nearest integer

Syntax

INT(number)

Lets chat on this