Mod (short for Modulus) is a useful Excel function that gives the remainder after performing a division calculation.

So ‘=Mod(10,3)’ (without the quote marks) gives the answer 1, which is the remainder after dividing 10 by 3. The Int function can be seen as a counterpart to Mod because it returns only the whole number result of a division and ignores the remainder, so ‘=Int(10,3)’ gives the answer 3.

Int and Mod are often used together, as in the example shown, where numbers of weeks can be converted into years and weeks instead of the decimal fraction of a year displayed in column B.