## 'INT function' category

Date and Time Functions – A to M

Table of Contents How to use the DATE function How to use the DATEDIF function How to use the DATEVALUE […]

Table of Contents How to use the DATE function How to use the DATEDIF function How to use the DATEVALUE […]

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

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

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

How to use Excel Tables

An Excel table allows you to easily sort, filter and sum values in a data set where values are related.

An Excel table allows you to easily sort, filter and sum values in a data set where values are related.

Calendar – monthly view

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

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

How to generate a round-robin tournament

This article demonstrates macros that create different types of round-robin tournaments. Table of contents Basic schedule - each team plays […]

This article demonstrates macros that create different types of round-robin tournaments. Table of contents Basic schedule - each team plays […]

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

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

Excel calendar

Table of Contents Excel monthly calendar - VBA Calendar Drop down lists Headers Calculating dates (formula) Conditional formatting Today Dates […]

Table of Contents Excel monthly calendar - VBA Calendar Drop down lists Headers Calculating dates (formula) Conditional formatting Today Dates […]

How to create permutations

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

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

Calculate machine utilization

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

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

## Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values