Explanation

TheYEAR functionextracts the year from a validExcel date.

Note: The SUMPRODUCT formula above is an example of usingBoolean logicin anarray operation.

This is a powerful and flexible approach to solving many problems in Excel.

Excel formula: Count dates in current month

SUMPRODUCT Function

The Excel SUMPRODUCT function multipliesrangesorarraystogether and returns the sum of products.

Excel formula: Count dates by day of week

Excel formula: Highlight dates in same month and year

Excel formula: Count birthdays by month

Excel YEAR function

Excel SUMPRODUCT function