Calculate the number of weeks between given dates
This article demonstrates Excel formulas that calculate complete weeks between two given dates and weeks and days between two given […]

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 […]

Calendar – monthly view
This article describes how to build a calendar showing all days in a chosen month with corresponding scheduled events. What's […]

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 […]

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]
Table of Contents Excel monthly calendar - VBA  Calendar Drop down lists Headers Calculating dates (formula) Conditional formatting Today Dates […]

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 […]