How to calculate average age by year/ month/ date in Excel

For example, you have a student roster with birthdays and ages in Excel, how could you calculate the average age by a given month or year? And what if calculating the average by a specific date in Excel? This article will introduce several tricks to solve them in Excel easily.

More details: