# INT function in Excel

> INT rounds a number down to the nearest whole number.

Source: https://spreadsheetpractice.com/functions/int · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** INT rounds a number down to the nearest whole number.
- **Syntax:** `=INT(number)`
- **Most common use:** `=INT(B2)` returns 8 (Drops the decimals: 8.9 becomes 8)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** The largest whole number that is no more than number.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

INT rounds a number down to the nearest whole number. For positive numbers that simply drops the decimals; for negative numbers it goes to the lower number, so -8.9 becomes -9. It's also the standard way to strip the time from a date-time value.

## Syntax

`=INT(number)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | The number to round down to a whole number. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| C2 | `=INT(B2)` | 8 | Drops the decimals: 8.9 becomes 8 |
| C3 | `=INT(B3)` | -9 | Rounds down, so -8.9 becomes -9, not -8 |
| C4 | `=B2-INT(B2)` | 0.9 | Subtracting INT leaves just the decimal part: 0.9 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C |
|---|---|---|---|
| 1 | Value | Number |  |
| 2 | Positive | 8.9 | 8 |
| 3 | Negative | -8.9 | -9 |
| 4 |  |  | 0.9 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Negative numbers are one lower than expected | INT rounds down, so -3.2 becomes -4. Use TRUNC to drop the decimals and keep -3. |
| A whole number dropped by one | The cell holds something like 4.9999 that the format shows as 5. Check the value in the formula bar and round the calculation feeding it. |
| The time disappeared from a date | That's what INT does to a date-time: it keeps the date. Use MOD(A2,1) if you want only the time. |

## Tips

- =INT(A2) on a date-time like 3/15/2026 14:30 returns just the date, which makes COUNTIF and lookups by day work.
- For whole weeks from a number of days, use =INT(B2/7).

## Related functions

- [TRUNC](https://spreadsheetpractice.com/functions/trunc): TRUNC cuts a number off at a set number of decimals without rounding.
- [ROUNDDOWN](https://spreadsheetpractice.com/functions/rounddown): ROUNDDOWN always rounds toward zero, dropping the extra digits whatever they are.
- [MOD](https://spreadsheetpractice.com/functions/mod): MOD returns the remainder after dividing one number by another.

## Questions

### How do I remove decimals in Excel without rounding?

For positive numbers use INT or TRUNC. For negative numbers use TRUNC, which keeps -3.7 as -3.

### How do I get the decimal part of a number?

Subtract the whole part: =A2-INT(A2). For positive numbers =MOD(A2,1) does the same.

### How do I remove the time from a date in Excel?

Use =INT(A2) and format the result as a date.

## Practice

A graded INT exercise ("Whole weeks of work") is on [the INT page](https://spreadsheetpractice.com/functions/int). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
