Count dates in given year
The YEAR function extracts the year from a valid Excel date. For example:
=YEAR("15-Jun-2021") // returns 2021
In this case, we are giving YEAR and array of dates in...Read more
Learn Excel with clear examples and bite-sized videos.
Featured Formulas
Featured Functions
RANK Function
The RANK function returns the rank of a numeric value compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e., the rank of highest test scores) and smallest to largest (i.e., the rank of fastest times in a race). You can use the RANK function to...Read more
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
Just wanted to drop in and say thank you! You've helped me solve SO MANY PROBLEMS over the years. Today, I learned the difference between Excel's FIND and SEARCH function and was able to write a formula that must have saved me hours of manual work.
Amanda
Thanks for the resources you provide. I've bumped into it as an avid Excel user (not at your level though) and have immediately seen the value - wow.
Antonie
I’m just one more person on your (probably ginormous) email list, but I just wanted to reach out and share that your website has helped me countless times (not even a spreadsheet could calculate the number!) throughout my life & career, and I’m very grateful that your passion and organizational skills coincided beautifully to make this website. Thank you for making your knowledge and experience freely accessible to the world! It’s had a big impact on me and I’m sure many others.
Andre
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.
