INT function

Excel » Functions » Math and trigonometry » INT function »

How to use the INT function

The INT function removes the decimal part from positive numbers and returns the whole number (integer) except negative values are […]

Days between two dates

The DATEDIF function in cell E3 allows you to calculate days between two dates.

Permutations with and without repetition

I discussed the difference between permutations and combinations in my last post, today I want to talk about two kinds […]

Find numbers closest to sum

Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]

Heat map yearly calendar

The calendar shown in the image above highlights events based on frequency. It is made only with a few conditional […]

Use a calendar to filter an Excel defined Table

This article demonstrates how to filter an Excel defined Table based on the selected cell in a calendar. The calendar […]

Excel calendar [VBA]

This workbook contains two worksheets, one worksheet shows a calendar and the other worksheet is used to store events. The […]

True round-robin tournament

Mark G asks in Create a random playlist in excel: Can this example be modified to create a true round-robin […]

Calculate machine utilization

Question: I need to calculate how many hours a machine is utilized in a company with a night and day […]