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
REGEXEXTRACT Function
The REGEXEXTRACT function extracts text matching a specific regex pattern from a given text string. For the advanced Excel user, this function is a major upgrade. Instead of working out complex formulas based on functions like LEFT, RIGHT, FIND, MID, etc., REGEXEXTRACT can target...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
I just found your website. It is great help. I'm only sorry that I did not find it earlier - it would save me a days of struggling with excel.
Pawel
I absolutely love your method of explaining Excel formulas and tips.
Shane
Knowing your site is the best thing that ever happened to me since I started using excel.
MJM
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.
