Featured Formulas

Date series

Semimonthly pay schedule

In this example, the goal is to create a list of pay dates that follow a semimonthly schedule. A semimonthly pay schedule means employees are paid twice a month, usually on fixed dates such as the 1st and 15th or the 15th and the last day of the month. This results in 24 pay periods over...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

FILTER Function

The FILTER function "filters" data based on one or more conditions, and extracts matching values. The conditions are provided as logical expressions that test the source data and return TRUE or FALSE. The result from FILTER is an array of matching values from...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

LOVE your site... wow... you have helped me quickly do a lot of things that would have taken me forever to figure out on my own. And I love that your search feature actually knows what I'm looking for... lol
Morgan
Just wanted to send a quick note of thanks for everything you've put together. I needed a formula but I didn't know how to explain what I wanted, but using the quicklinks at the bottom of every page eventually got me there. I didn't even know such a formula existed, let alone a clear and in-depth description of how it works!
Maree
I am a self taught Excel user and love the simple, concise instruction videos. When I have downtime at work, I find myself eager to come to this site and see what new function I can learn and then try to figure out how to incorporate it into my work.
Toni
More Testimonials

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