Featured Formulas

Count cells between dates

In this example, the goal is to count the number of cells in column D that contain dates that are between two variable dates in G4 and G5. This problem can be solved with the COUNTIFS function or the SUMPRODUCT function, as explained below. For convenience, the worksheet contains two...Read more

Featured Functions

VSTACK Function

The Excel VSTACK function combines arrays vertically into a single array. Each subsequent array is appended to the bottom of the previous array. The result from VSTACK is a single array that spills onto the worksheet into multiple cells....Read more

Recent Articles

I just have to say I have been using your site for two years and the lessons that I have learned from your clear direction on Excel formulas have led to a successful change in my career. Your site and instruction is clear, concise, and perfect!
Jennifer
I always appreciate getting your notifications, even when I don’t think I can use the tips at the time. They are clear, step by step, and perfectly logical, which I cannot say for other excel tips of which I am aware. I also appreciate your visual examples, which are so necessary for visual people like me!
Stanley
I frequently use the resources you provide here on your website, and wanted to thank you for the awesome work you are doing. It is very well done, has great breadth, and lays out complex topics in an understandable way.
Chase

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