Count birthdays by month
You would think you could use the COUNTIF function to count birthdays, but the trouble is COUNTIF only works with ranges, and won't let you use something like MONTH to extract just the month number from...Read more
Learn Excel with clear examples and bite-sized videos.
Featured Functions
Recent Articles
Seeded Random Number Generator in Excel
How to keep random numbers from changing in Excel? Excel's random functions like RAND and RANDARRAY recalculate every time you edit your worksheet, making it impossible to maintain stable random results. This article shows you how to build a seeded random number generator using Excel's...Read more
Topics By Category
User Testimonials
I just wanted to reach out and thank you for your excellent work. I'm an avid reader of the Exceljet newsletter and frequently refer to your website for very useful clarifications. I use Excel a lot in my work as a data analyst and have taught Excel classes on many occasions. You may therefore consider that my appreciation of your work is based on an expert opinion. ;)
Tim
Just a brief view of your website, and one specific idea - a "helper" value column - allowed me to do in less than two hours something I had been going down dead-ends with for two days. Thank you, thank you, thank you!
Roberta
I just wanted to say thank you for building such an amazing resource. I'm an intern at a tech company and a lot of my projects require heavy use of excel. I've been using this website for everything from formatting to building a fully functional financial modeling tool. I have never used excel before but resources like this leave me feeling confident and capable. :)
Sunny
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.
