Featured Formulas

Date series

Sequence of workdays

To create a list of workdays that exclude weekends and holidays, you can use a formula based on the SEQUENCE function inside the WORKDAY.INTL function. In the example shown, the formula in D5 is: =WORKDAY.INTL(B5-1,SEQUENCE(12),1,B8:B11) The result …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Text

TEXT Function

The Excel TEXT function returns a number formatted as text. This makes it easy to embed a formatted number (e.g., dates, times, currencies, percentages, fractions, etc.) in a text string with the number format of your choice.Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I just wanted to say that I have been using Excel for many years, but my go-to site is always ExcelJet. Always clear and concise with superb examples on use (far superior to even Microsoft Support!).
Gordon
The best site I ever found on any programming/software topic on the Internet. Period! I can not find words to express my admiration for the clarity, precision and insight with which you put your site together. Thank you.
Mario
Just wanted to say thank you for the many clear, concise, and informative articles. I've gone from complete novice to regularly using array formulas thanks almost entirely to your site.
Scott
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