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

TEXTJOIN Function

The TEXTJOIN function concatenates multiple values together with or without a delimiter. TEXTJOIN can concatenate values provided as cell references,  ranges, or constants, and can optionally ignore empty cells.

The TEXTJOIN function...Read more

Recent Articles

I've been learning from exceljet.com for a while now and I think it's about time I contributed to your cause. Thank you very much. Your excel knowledge helped me in my job many times in the past. When I saw your index/Match today I realized how much I still need to learn. I am a Mechanical engineer. I will be using your file in my work. I've shared it with the other engineers here.
Sam
Thank you for all the hard work you put into developing this awesome site. I have been using it for years, the knowledge and skills I gained helped me throughout my professional career; saving me hundreds of hours of extra work, so thank you for sharing your knowledge and support.
Anas
I just subscribed recently, and I love your email tips and the good info on your web site.
Walt

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