Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

YEARFRAC

Convert Dates into Ages

By Jeff Lenning | August 1, 2023 |

If you need to calculate the age in years based on a list of birth dates in Excel, fear not! In this short tutorial, we’ll cover a few functions that will help, as well as a method to count the number of rows in each age group. Specifically, we’ll explore the YEARFRAC, TRUNC, DATEDIF, and…

Read More