INT(...)-INT(...)-1
Get days between two dates excluding start date
Used Functions
Category: Math and trigonometry
Rounds a number down to the nearest integer
Syntax
INT(number)
Practice INT Formula at Sheetzoom
INT formula at Microsoft help
0
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.