Featured Formulas

Generate quarter dates

In this example, the goal is to generate a list of quarter start and quarter end dates. This can be done by combining the SEQUENCE function with the EDATE and EOMONTH functions, as explained below.

The SEQUENCE function

The SEQUENCE...Read more

Featured Functions

SEARCH Function

The SEARCH function returns the position (as a number) of one text string inside another. In the most basic case, you can use SEARCH to locate the position of a substring in a text string. You can also use SEARCH to check if a cell contains specific text....Read more

Recent Articles

What a nice job. Your web site is my "go-to" place for any help with Excel!
Vimal
I find your site invaluable and a fantastic resource whenever I need to give Excel a spin and accomplish a challenging task.
Steve
Thanks again for all that you have given to the Excel community over the years. I have referred to your site countless times when trying to figure out how to bend Excel to my wishes.
Eric

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages