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
Recent Articles
Native checkboxes in Excel
If you've ever tried to create a to-do list, survey, or any kind of checklist in Excel, you've probably wished for a simple checkbox feature. Well, your wish has finally come true. Microsoft has finally introduced a native checkbox feature in Excel. It's easy to use
...Read more
Topics By Category
User Testimonials
I always appreciate getting your notifications, even when I don’t think I can use the tips at the time. They are clear, step by step, and perfectly logical, which I cannot say for other excel tips of which I am aware. I also appreciate your visual examples, which are so necessary for visual people like me!
Stanley
Thanks again for all that you have given to the Excel community over the years. I have referred to your site countless times when trying to figure out how to bend Excel to my wishes.
Eric
I just wanted to say thank you for this formula =SUMPRODUCT(--ISNUMBER(SEARCH(things,A1)))>0. It has proven to be one of the most useful formulas I have ever used.... especially when you're daily checking a 1.k5+ row list against a 50k row list.
Ben
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.
