Please enable JavaScript to view the comments powered by Disqus.


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

Calculate dates between two dates

The formula subtracts the start date from the end date to get the day count. INT() function ensures that we have only integer part from the input dates.


Used Functions

Category: Math and trigonometry

Rounds a number down to the nearest integer

Syntax

INT(number)

Lets chat on this