INT Function
Rounds a number down to the nearest whole number.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A whole number
Want to practice INT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
INT drops the decimals by rounding down. For positive numbers that just removes the decimals; for negatives it goes one lower (−2.5 → −3).
A favourite trick: INT of a date-time returns just the date.
Syntax
=INT(number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The number to round down. |
Examples
Example 1 — Whole units
Whole kilograms from weights.
B2fx=INT(A2)
| A | B | |
|---|---|---|
| 1 | Weight | Whole kg |
| 2 | 8.9 | 8 |
| 3 | 12.2 | 12 |
| 4 | -2.5 | -3 |
=INT(A2) Explain
Example 2 — Date without the time
A2 holds 15/03/2026 14:30.
=INT(A2) Explain
Format the result as a date. The time part — the decimal — is gone.
Common mistakes
- Negatives. INT(−2.5) is −3, not −2. Use TRUNC to simply chop off decimals.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.