How to Calculate Working Days Passed in Current Month
When working with dates, you'll sometimes find that you need to calculate the number of working (or business days) that have passed in...
top of page
Recent Posts
How to Calculate Working Days in a Month
When working with dates, you'll sometimes find that you need to calculate the number of working (or business days) in a month, from a...
How to Use the OCT2BIN Function
The OCT2BIN function converts octal numbers into binary form. Contents: 1. Syntax 2. Explanation 2.1. What is an Octal Number 2.2. What...
How to Convert Large Decimal Numbers to Binary
There are lots of ways to convert decimal numbers into binary. Excel has a built in function for small numbers, but you'll need a custom...
How to Convert Large Binary Numbers to Decimal in Excel
There are two good ways of converting binary to decimal. Excel has a built in function for small numbers, but you'll need a custom...
How to Perform a Two-Way XLOOKUP
A regular, one-way XLOOKUP, is a fantastic tool, but sometimes you may find yourself needing to lookup a value in two different...
How to Unstack Uneven Data From a List in Excel
While the WRAPROWS function can be great to unstack a list with an even number of items, we'll need a custom formula to wrap, or unstack...
How to Reverse or Flip First and Last Names in Excel
You'll often see names that are out of order, and need to flip them. Here are a couple quick formulas to help you accomplish that task....
How to Create Index Columns Using Dynamically Spilled Arrays
Add an index column to any dynamic array using a few of the latest Excel functions for easy lookups. Contents: 1. Adding Index Column to...
How to Create a Dynamic Array of Repeating Cells
Create a repeating list based off of a range and a specific numbers of repetitions. Contents: 1. Formula 2. Explanation Formula To...
How to Calculate Number of Days Between Two Dates in Excel
A short formula you can use to calculate the number of days between two specific dates. Contents: 1. Formula 2. Explanation 3. Example...
How to Calculate Weekend Days Between Two Dates in Excel
An easy formula you can use to calculate the number of weekend days between two specific dates. Contents: 1. Formulas 2. Explanation 3....
How to Calculate Number of Weekdays Left in the Current Month in Excel
A quick formula to calculate the number of weekdays, business days, or working days remaining in the current month. Contents: 1. Formulas...
How to Link Workbooks in Excel
When working with multiple Excel workbooks, you'll often find yourself needing to reference numbers from one workbook in a separate...
How to Round a Price to .99 in Excel
When working with prices, it can often be beneficial to round to the nearest .99 cents. There are a few formulas we can use depending on...
How to Calculate Flow Rate in Excel
Flow rate can be tricky to calculate, but if you have all of the required pieces we can create some easy Excel formulas to do the work...
How to Calculate Weighted Average in Excel
A weighted average is an average where each value has a different level of importance, represented by a weight, which affects the overall...
How to Sum Cells By Color in Excel
While not a built-in Excel feature, we can create our own function to easily sum cells by color. Contents: 1. How to Use VBA User Defined...
How to Highlight Weekends in Excel
Using conditional formatting, we can use a custom formula to highlight all weekend dates from any date range, letting you visually see...
How to Return the Second to Last Item in a List in Excel
Usually, you need to return the last or first item in a list, but every once in a while, you may find yourself needing to return the...
bottom of page