Please enable JavaScript to view the comments powered by Disqus.


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

Get days between two dates excluding start date

This formula calculates the days between two dates. In Excel, dates are actually numbers so you can easily do mathematical operations. This formula does not take into consideration the hours.


Used Functions

Category: Math and trigonometry

Rounds a number down to the nearest integer

Syntax

INT(number)

Lets chat on this