(...)
How to calculate difference between two dates
Used Functions
Category: Math and trigonometry
Rounds a number down to the nearest integer
Syntax
INT(number)
Category: Math and trigonometry
Rounds a number down to the nearest integer
INT(number)
Practice INT Formula at Sheetzoom
INT formula at Microsoft help
0
The formula uses the fact the MS Excel considers dates as simple numbers starting from 1st Jan 1900. Thus the difference between two dates gives the number of days.