QUOTIENT Function
Returns the whole-number part of a division.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A whole number
Want to practice QUOTIENT 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
QUOTIENT divides and throws away the remainder: QUOTIENT(30, 12) is 2.
Pair it with MOD to split a number into “how many whole” and “how many left over”.
Syntax
=QUOTIENT(numerator, denominator) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| numerator | Yes | The number to divide. |
| denominator | Yes | The number to divide by. |
Examples
Example 1 — Weeks and days
Turn a number of days into whole weeks plus days.
B2fx=QUOTIENT(A2, 7)&" wk "&MOD(A2, 7)&" d"
| A | B | |
|---|---|---|
| 1 | Days | Weeks + days |
| 2 | 30 | 4 wk 2 d |
| 3 | 14 | 2 wk 0 d |
| 4 | 45 | 6 wk 3 d |
=QUOTIENT(A2, 7)&" wk "&MOD(A2, 7)&" d" Explain
Common mistakes
- Negatives. QUOTIENT truncates towards zero: QUOTIENT(−7, 2) is −3, while INT(−7/2) is −4.
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.