Featured Formulas

Date and Time

Join date and text

To join a date with text, you can use concatenation with the TEXT function to control the date format. In the example shown, the formula in D5 is: ="The date is "&TEXT(B5,"dddd, mmmm d, yyyy") The result is the text string "The date is Friday, …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Date and time

NETWORKDAYS Function

The Excel NETWORKDAYS function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates.Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Just wanted to say thank you both so much for providing this incredibly valuable and thorough resource for free. I've used your website to get me through my classes as a graduate student, and I currently use your website for my work with a State agency conducting data analysis for disease.
Jenn
Just did a quick google on a question about Excel and Boom....up popped the link to your site. My solution was found and implemented within minutes, and I had one of those "running around the office" moments (we've all been there!). Some great information on there...Thanks & keep up the good work!
Phil
I sincerely want to register my profound gratitude to Dave and Lisa. There are many features so unique about the tutorials in Exceljet: the simplicity, down-to-earth approach and the connection between the instructor and the learner.
John
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