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

Extract specific word based on position in cell value
Table of Contents Extract first word in cell value Extract the first word in cell - return warning if not […]

How to use the RIGHT function
What is the RIGHT function? The RIGHT function extracts a specific number of characters always starting from the right. What […]

How to group items by quarter using formulas
This article demonstrates two formulas, the first formula counts items by quarter and the second formula extracts the corresponding items […]

Working with classic ciphers in Excel
What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

Fuzzy lookups
In this post I will describe a basic user defined function with better search functionality than the array formula in […]

Extract unique distinct values based on the 4 last characters
Sean asks: The good thing about this formula is that it is short and easy to remember. The main drawback […]

Formula for matching a date within a date range
This article demonstrates how to match a specified date to date ranges. The image above shows a formula in cell […]

5 easy ways to VLOOKUP and return multiple values
This post explains how to lookup a value and return multiple values. No array formula required.