Sometimes, the data in your spreadsheet may not be formatted as you need it to be. Removing extra characters can be tedious, and doing it manually is time-consuming and prone to error. Luckily, there are easy ways to manipulate data using Excel functions and formulas. In this article, you will learn how to remove last […]

I received a lot of questions on how to use the IF function with 3 conditions, so I’ve decided to write an article on this topic. The IF examples described in this article assume that you have a basic understanding of how the IF function works. All examples from this article work in Excel for […]

You can count all cells not equal to x or y using a simple COUNTIFS formula. If you only want to count using one condition, then you can also use COUNTIF as an alternative. I’ll explain both in this short tutorial. Count cells not equal to x or y using COUNTIFS The COUNTIFS syntax for […]

If you are looking to count cells not between two numbers in Excel using COUNTIFS, then you are in for disappointment. That’s because COUNTIFS uses the AND logic when comparing the criteria, resulting in an always FALSE result. And that makes sense since a number can’t be, for example, higher than 100 and lower than […]

To get the first day of the month for a given date, you can use two simple approaches: using EOMONTH function or using DAY function.