Calculate Years & Months of Service in Excel | DATEDIF Function Explained#exceltips #exceltricks

welcome to MSD EXCEL

Want to calculate how long someone has served in a company using their joining date? 🤔
In this video, I’ll show you Excel’s hidden DATEDIF function to easily calculate years and months of service step by step.

👉 Formula Used:

=DATEDIF(A2,TODAY(),"y") & " Years " & DATEDIF(A2,TODAY(),"ym") & " Months"

This quick tutorial is perfect for HR, students, and Excel beginners who want to calculate service length, work experience, or employee tenure.

📌 Watch the full steps here:
https://youtube.com/shorts/2vGgitwbBXE?si=i1cJS5digCUPWQbQ

⚡ What You’ll Learn:

Excel’s DATEDIF function (hidden but powerful)

How to calculate years of service

How to calculate months of service

Combine years + months for professional reports
✅ No copyright content – 100% original Excel tutorial.

Subscribe to MSD Excel for more easy Excel formulas, tips, and tricks! 🚀
---
#ExcelFormulas #ExcelTips #ExcelShorts #ExcelHacks #ExcelBasics #ExcelMagic #ExcelTutorial #ExcelFormulaTricks #ExcelProTips #MSDExcel #ExcelDatedif #ExcelLearning #ExcelForBeginners #ExcelFunctions #ytshorts
---

#exceltips #exceltricks #excelformulas

#shorts #ytshorts

Видео Calculate Years & Months of Service in Excel | DATEDIF Function Explained#exceltips #exceltricks канала Msd excel