🚀 Excel Tip of the Day! 📊 Want to calculate age or duration in Years, Months, and Days — all at once? Try this amazing formula: =DATEDIF(B2:B11, TODAY(), {"Y","YM","MD"}) 🔍 What it does: This array formula gives you the difference between a list of dates and today’s date — broken down into: Years ("Y") Remaining Months after years ("YM") Remaining Days after months ("MD") 📌 Great for: HR age calculations Service duration Membership aging Customer profiling 💡 Bonus Tip: Use TEXTJOIN to combi

23 reactions · 23 shares | Calculate age in Excel from Date of Birth in Years, Months, and Days || Use of datedif in MS Excel #excel #msexcel #Microsoft365 #calculateageinexcel #datedif #formatcell | Trick and click | Facebook