Datedif years and months || Datedif today || How to Calculate age in Excel ||
Hi Mates,
In this video, you'll learn to calculate the methodology on three aspects
1.Year
2.Month
3. Days
With the help of independent DATEDIF() formula.
For example, to get years, months, and days separately between any given two dates in excel. Take help of below example using cell references instead of using actual dates:
=DATEDIF(A2,B2,”y”) &” years," & DATEDIF(A2,B2, ”ym”) & ” months,“ &DATEDIF(A2,B2, ”md”) & ” days”.
#Datedif
#NaveenVBA
#ExcelTips
(Example can be downloaded from description)
File Download Link :
►https://drive.google.com/file/d/1ZZET...
Check out other important video links :
1. UNBEATBALE XLOOKUP | XLOOKUP VBA | HOW TO USE XLOOKUP VBA | XLOOKUP VS INDEX MATCH AND VLOOKUP |
► • Xlookup in hindi | XLOOKUP VBA | HOW ...
2. How to create Gantt Chart in Excel | Create a Basic Gantt Chart in Excel | Gantt Chart excel |
► • How to create Gantt Chart in Excel | ...
3. Data cleaning in Excel | Best Excel Tricks to Clean Data | Raw Data Clean | Excel Data Cleaning |
► • Data cleaning in Excel | Best Excel T...
4. VLOOKUP WITH CONCATENATE | Excel Magic Trick - VLOOKUP Return Two Values to One Cell or Two Cells |
► • VLOOKUP WITH CONCATENATE | Excel Magi...
5. Partial Match with VLOOKUP in Excel | MS Excel - VLookup Approximate Match | Wildcard in Vlookup | Excel VLOOKUP Function - All You Need To Know |
► • Partial Match with VLOOKUP in Excel |...
6. 7 Most Used Excel Formula ☑️ 📈 Advanced Excel Formulas 📈 Important Excel Formulas 📈
► • 7 Most Used Excel Formula ☑️ 📈 Advanc...
Subscribe NaveenTamtaVBA
► / naveentamtaiamexcelvba
► / @naveentamtaiamexcelvba
► / naveentamtavba
►LinkedIn: / naveen-tamta-859691112
Note: This description contains affiliate links, which means at no additional cost to you. This helps support the channel and allows me to continue to make videos like this. Thank you for your support!
Thanks For Watching #NaveenTamtaVBA
Tags
datedif years and months,
datedif today
datedif not working
datedif excel 2016
datedif excel 2007
datedif excel 2010
datedif excel 2013
datedif excel 2019
datedif office 365
datedif formula with example
datedif excel not found
datedif alternative
datedif weeks
