How to find the last day of a month in Excel

How to find the last day of a month in Excel

In this article, we are going to show you how to find the last day of a month in Excel. Download Workbook We will be using two functions to find the last day of a month in Excel: DAY and EOMONTH. =DAY(EOMONTH(<Date>,0)) The EOMONTH returns the date value of the...
Implicit vs Explicit Intersections in Excel

Implicit vs Explicit Intersections in Excel

Formula intersections can help simplify your formulas. There are 2 types of intersections in Excel: implicit and explicit. In this guide, we’re going to show you implicit vs explicit intersections in Excel. Download Workbook Implicit Intersections If you are using...
How to remove spaces in Excel

How to remove spaces in Excel

If you are working with data from different sources, you’ve more than likely came across unwanted spaces in the data. In this guide, we’re going to show you how to remove spaces in Excel. Download Workbook There are mainly two ways you can use to remove spaces...
Box-and-Whisker Charts

Box-and-Whisker Charts

A box-and-whisker chart is a visualization of groups of numerical data and their quartiles in the data set. Originally named boxplot chart, this visualization gets its name from a box that represents the lower and upper quartiles, and lines extending from the box...