Say goodbye to late nights and spreadsheet struggles! excel-university.com/challenge Your ticket to freedom has arrived with Excel University Speed Challenge Unlock hidden Excel tricks and hacks, and become a time-saving Excel pro. ️ Don’t miss out, join now! excel-university.com/challenge

Subscribe here https://www.youtube.com/@ExcelU and turn on all notifications for MS Excel formula hacks that will make you more productive!

Learn how to convert a list of dates into ages (in years) and summarize them by counting how many are within groups such as 18-25, 25-30, and so on. Specifically, this video demonstrates the following Excel functions:
– YEARFRAC
– TRUNC
– DATEDIF
– COUNTIFS

Chapters in this video:
00:00 – Introduction
00:20 – YEARFRAC
01:56 – DATEDIF
02:48 – COUNTIFS

Please take the opportunity to connect and share this video with your friends and family if you find it useful.