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
TRIMRANGE Function
The TRIMRANGE function removes empty rows and columns from the outer edges of a range of data. Given a range or array, it will exclude empty rows and/or columns and return a "trimmed" range that contains only data. The beauty of TRIMRANGE is that it will track the data in a worksheet as it...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 say you are my go to website for any excel question for good few years and taught me a lot. No other resource can explain the steps better than you do. You made such a difference. It is amazing.
Al
Just a really quick note to say thanks for the "normalize size units to gigabytes" formula -- it's one of the very few times in my 25+ year career that I've found a help page on the net where the suggested solution worked perfectly, unmodified.
Ian
I have learned so much from your courses. I am patiently awaiting a VBA course. Your teaching methods are spot on, easy to follow and concise. I appreciate all the help you have given me.
Sam
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.
