Age Calculation kaise kare #excel #exceltips#agecalculation #agecalculator

Age Calculation kaise kare #excel #exceltips#agecalculation #agecalculator

Calculate Age or Date Difference in Excel Without DATEDIF!

Want to calculate years, months, and days between two dates in Excel without using the DATEDIF function? Here's a simple formula:

excel
Copy
Edit
=INT((A2-B2)/365) & " Years, " & INT(MOD(A2-B2,365)/30) & " Months, " & MOD(A2-B2,30) & " Days"
✅ This formula helps you:
✔️ Find the number of full years 📅
✔️ Calculate remaining months 📆
✔️ Get the exact number of leftover days ⏳

🔹 Example:
If Start Date = 22-Mar-1989 and End Date = 21-Feb-2025, the result will be:
35 Years, 11 Month, 10 Days 🎯

📌 Limitations:
⚠️ This formula assumes 365 days per year and 30 days per month, so it may not be 100% accurate for leap years or months with 31 days.

📺 Watch, Learn & Subscribe! 🎥💡
#ExcelTips #ExcelFormula #DateDifference #ExcelShortcuts #Spreadsheet #LearnExcel
#agecalculation #agecalculator #exceltricks #excelbeginner #excelbasics #excelbasic #serialnumber #basudevswain #Accountsfix
calculate age in excel,how to calculate age in excel from birthday,how to calculate age in excel,age calculation in excel,age calculator in excel,how to calculate age from date of birth in excel,how to count age in excel,age calculation,how to calculate age with an excel formula,how to calculate age in excel from a date of birth,how to calculate age in ms excel,excel formula to calculate age on a specific date,how to calculate age from a specific date in excel

Top 10 Most useful Shortcut in Excel
https://youtu.be/TYZh2MsHDF8?si=kg2GBrr8geRAzyGL
@AccountsFix

Видео Age Calculation kaise kare #excel #exceltips#agecalculation #agecalculator канала Accounts Fix