56K views · 515 reactions | How to count Years, Months and Days using Today and Datedif function. #exceltips #Excel | Excel Basics | Facebook

498K views · 4.7K reactions |  Excel Tip Alert! Use the DATEDIF function to calculate the difference between dates in years, months, and days simultaneously! Example: excel Copy code =DATEDIF(B2:B11,TODAY(),{"Y","YM","MD"}) Breakdown: ✅ "Y" - Total years ✅ "YM" - Remaining months after years ✅ "MD" - Remaining days after months  Perfect for tracking durations! #ExcelTips #ExcelFunctions #Productivity | Excel By Vikal | Facebook

Want to calculate age in Excel effortlessly? Learn how to use the DATEDIF function to find age based on: ✅ Today's Date using TODAY() ✅ A specific date value from a cell In this tutorial, I’ll walk you through step-by-step: Writing the formula: =DATEDIF(start_date, end_date, "y") How TODAY() dynamically calculates the age as the current date changes Using a cell reference for a custom date input 📌 Perfect for tracking ages in HR databases, event planning, and more! Watch now and master this sim