Featured Formulas

Sequence of custom days

The goal is to generate a series of "custom" days of the week based on a start date entered in cell B5. For example, you might want to list sequential dates for any of the following combinations of days:

  • Mondays, Wednesdays, and Fridays (as shown)
  • ...Read more

Featured Functions

HYPERLINK Function

The HYPERLINK function creates a hyperlink to a given destination with a "friendly name", which is simply the anchor text. You can use HYPERLINK to construct a clickable hyperlink with a formula. The HYPERLINK function can build links to other cells in a workbook, other sheets, named...Read more

Recent Articles

I don't often do this, but i've subscribed to your tips for a little while now. I think they come from Dave. I just wanted to say these are absolutely awesome and they have significantly helped me build my excel skills.
Mike
This is the best site I have been to. Direct & to the point. You guys have (almost) everything I need on one site.
Carl
I love your website! I use it all the time. In fact, I used it over the past few weeks to help me make a great workbook. keep up the great work, and thanks for all the help your site has given me.
Steve

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