The INT function
The integer just below: 7.9 gives 7. Very handy to remove the time from a date.
Syntax
=INT(number)
In a French Excel: =ENT(nombre).
Arguments
- number: the value to round down.
An example
=INT(A2)
If A2 contains 15/03/2024 at 14:30, returns 15/03/2024 at midnight (format it as a date).
Pitfalls
- Negatives go down: -2.5 gives -3. To cut decimals without rounding, TRUNC.
- A date result shows as a number if the cell is not formatted as a date.
Going further
Frequently asked questions
- INT or TRUNC?
- The same for positives; for negatives, INT goes down (-3), TRUNC cuts (-2).