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
HYPERLINK Function
The HYPERLINK function creates a hyperlink to a given destination with a "friendly name", which is simply the anchor text. You can use HYPERLINK to construct a clickable hyperlink with a formula. The HYPERLINK function can build links to other cells in a workbook, other sheets, named...Read more
Recent Articles
How to replace Excel's DATEDIF function
Excel's DATEDIF function is widely used for calculating the difference between two dates in years, months, or days, but it will silently return buggy results in specific cases. DATEDIF2 is a custom LAMBDA function that replaces DATEDIF with reliable date arithmetic. This article explains...Read more
Topics By Category
User Testimonials
I am very very grateful to this particular website as I have got an exposure to a large number of examples with the latest formulae, and practical examples have been beautifully illustrated & explained in simplified ways.
Shubhrojyoti
Your website is fantastic! I've looked at dozens of Excel tutorial sites. None compare favorably. Thank you for your assistance.
Marco
I really love these quick tip videos, really reinforces my love for Excel.
Trina
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.
