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

TEXTAFTER Function

The Excel TEXTAFTER function extracts text that occurs after a given delimiter. When multiple delimiters appear in the text, TEXTAFTER can return text that occurs after the nth instance of the delimiter. TEXTAFTER can also extract text after a specific delimiter when counting...Read more

Recent Articles

I absolutely LUV your explanations and examples! You have saved me a lot of time and frustration. Thank you, thank you, thank you.
Katalin
No matter how much you try learn and grasp... Excel and its formulas are endless. I would like to thank you for helping me whenever i forget something.
Sushant
...thank you for a really useful resource that you have established for Excel… I really find it very helpful and use it frequently when I am looking to do something that I have not done before… really very useful :)
Michael

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