Summary

The Excel INT function rounds a number down to the nearest integer. For positive values, that often looks like simply removing the decimal part: =INT(4.9) returns 4. The distinction becomes more important with negative values, because INT does not move toward zero. Instead, it moves toward negative infinity, so =INT(-4.9) returns -5.

That behavior makes INT the correct choice when you need the mathematical floor of a value. It is also useful for date-time work because Excel stores dates as whole numbers and times as fractional parts of a day. Applying INT to a datetime removes the time portion and leaves the date serial behind, which you can then format as a date.

Syntax

=INT(number)

INT takes one required argument: the number you want to round down. That input can be a constant, a cell reference, or a formula result. The function has no precision argument, so it always rounds to a whole number. If you need to remove decimals without changing negative values as aggressively, TRUNC is usually the better tool.

Arguments

• number - [Required] The real number to round down to an integer. It can come directly from a typed value, a referenced cell, or another formula.

INT vs Other Functions

INT, TRUNC, and ROUNDDOWN can all remove decimal places, but they are not interchangeable. The difference matters most when negative values appear in the data or when you need control over decimal precision.

For positive numbers, INT and TRUNC often appear identical. The moment negative numbers enter the worksheet, the conceptual difference becomes operational. If the requirement is "floor the number," use INT. If the requirement is "remove the decimal part," TRUNC usually matches that wording more closely.

Using INT

A common use of INT is extracting the date from a datetime. In Excel's serial system, the integer part stores the date and the decimal part stores the time. When you write =INT(A1) against a datetime such as 2024-01-05 14:30, the result is the serial for 2024-01-05. That is a direct and dependable way to remove time without text conversion.

INT is also useful in allocation and batching formulas. If you divide a total quantity by a pack size, the decimal portion represents a partial pack. Wrapping the division in INT gives the number of complete packs only. That same logic applies to capacity planning, scheduling, and any calculation where only fully completed units should count.

• Use =INT(datetime) to remove the time portion from a datetime serial.
• Use =INT(time*24) to extract completed hours from an Excel time value.
• Use =INT(total/size) when partial units should be ignored and only complete groups matter.

Example 1 - Strip the Decimal from a Number

This is the most direct application of INT. The function returns the next lower integer, so 4.9 becomes 4. The result is not based on standard rounding rules; the decimal portion is not evaluated for 5 or above. The only question INT asks is which integer lies immediately below the value.

=INT(4.9)    // 4
=INT(7.1)    // 7
=INT(10.99)  // 10

Example 2 - Extract the Hour from a Time Value

Excel stores time as a fraction of one day. Multiplying by 24 converts that fraction into decimal hours. INT then removes the fractional hour, leaving only the completed hour count. This is useful when building hour-based summaries from timestamps without needing minute-level detail.

=INT(B2*24)
// B2 = 0.5208
// 0.5208 * 24 = about 12.5
// INT returns 12

Example 3 - Count Whole Days Between Two Dates

Date subtraction returns the difference in days, including any fractional day caused by times. INT removes that fraction and keeps only full days completed between the start and end values. That is appropriate when the business rule counts only complete days, not partial ones.

=INT(C3-B3)
// B3 = "2024-01-01"
// C3 = "2024-03-15"
// Result = 74

Example 4 - Get the Whole Number Part of a Division

Division often produces a useful remainder, but sometimes the only relevant question is how many full groups fit into the total. INT answers that question directly. With 47 items and a group size of 5, the calculation produces 9.4, and INT reduces that to 9 complete groups.

=INT(B4/C4)
// B4 = 47, C4 = 5
// 47/5 = 9.4
// INT returns 9

One practical caution: INT is not always the right tool when negative numbers are present. A value such as -2.1 becomes -3, which is mathematically correct for a floor but may not match a business interpretation of "drop the decimals." When the sign of the number can vary, review whether INT or TRUNC better matches the intent.

• Use INT when the requirement is mathematically "round down."
• Use TRUNC when the requirement is "remove decimals" and the dataset may include negative values.
• Use INT with datetime serials when you want a numeric date result that can still be formatted and calculated further.

Conclusion Recap

• Summary: INT rounds a value down to the nearest integer.
• Syntax: =INT(number) with one required argument.
• Key distinction: INT floors negative numbers, so INT(-4.9) returns -5.
• Practical usage: Remove time from datetimes, extract completed hours, and count only full groups in allocation formulas.