ExcelHeroThe ROUNDDOWN function
Always rounds towards zero.
In German Excel: ABRUNDEN
How to write it
=ROUNDDOWN(number, num_digits)- number
- The number to round.
- num_digits
- Digits to keep.
💡 Use it for “full weeks” or “complete sets”.
Try it
How many full weeks are 45 days?
A
B
1
Days
45
2
Full weeks
Divide by 7 and drop the rest.