Count dates in given year
To count dates in a given year, you can use the SUMPRODUCT and YEAR functions. In the example shown, the formula in E5 is: =SUMPRODUCT(--(YEAR(dates)=D5)) where dates is the named range B5:B15.Read more
Learn Excel with clear examples and bite-sized videos.
Featured Functions
REGEXTEST Function
The Excel REGEXTEST function tests for the existence of text defined by a given pattern. Regex patterns are very flexible and can be configured to match numbers, email addresses, dates, and other values that have an identifiable pattern. The result from REGEXTEST is TRUE or FALSE. The …Read more
Recent Articles
Combinations and permutations in Excel
Combinations and permutations are two basic ways to count possibilities, used in probability, statistics, games, passwords, and lotteries. This article explains the difference between them, when order and repetition matter, and the Excel functions you can use to calculate each case: FACT, PERMUT, …Read more
Topics By Category
User Testimonials
One of the best investments I have made is purchasing a number of video training courses offered by excelJet. In addition, the articles provided are excellent and ensure my Excel skills remain up to date and relevant.
Peter
Since I started working 6 months ago, I've been using Excel extensively. And I cannot put in words how grateful I am. You've been helping me alot with your blog posts! Thanks!
Fabricio
I also wanted to let you know that I learn a ton a get a lot of value from your tutorials. Very much appreciated.
Patrick
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.
