How To Calculate Difference in Two Dates In Excel | Very Easy Excel Formula For Date | Excel Lecture

#Excel #ExcelforBeginners #excelbyneerajarora #msexcel
In this Ms-Excel tutorial video, I will show you how to calculate the difference between two dates in Excel.
The most suitable function to do this kind of calculation is DATEDIF() function. To know more in detail watch this video till the end.
Till the end of this video, you’ll be able to conveniently use Excel formulas to figure out the exact number of years, months and days passed between two dates.
नमस्ते दोस्तों आज की वीडियो में हम समझेंगे कैसे आप Excel में दो Dates के बीच में बहुत ही simple तरीके से difference निकाल सकते हैं |
मैं आपको एक बहुत ही simple formula बताने जा रहा हूँ जो है datedif() इस formule की मदद से आप आसानी से दो dates के बीच में difference निकाल सकते हैं |
======
Timestamps:
00:00 : Introduction
0:10 : How To Find Difference Between Two Dates In Terms Of Years
0:55 : How To Find Difference Between Two Dates In Terms Of Months
1:38 : How To Find Difference Between Two Dates In Terms Of Days
2:05 : Conclusion
=======
About Neeraj Arora
Neeraj Arora is a renowned teacher for courses/qualifications like CA, ACCA. He is also known for imparting knowledge on Investing, Personal Finance to the young minds of India. He is the co-founder of EDU91 & Skill91. His areas of teaching and studying include Auditing, Strategic Management, Income Tax, GST, Investing, Stock markets, Personal Finance, Excel, etc. He always believes in सीखना बंद तो जीतना बंद।
===========
🔥 Learn & Master Excel With 4500+ Students Across India on Excel Club 🔥
Link: www.skill91.com/s/store/cours...
😍 Why Choose Excel Club By Neeraj Arora? 😍
✅ 50+ Detailed pre-recorded videos highlighting every feature & function of Excel.
✅ Access anytime & anywhere On Android, iOS, and Web. Breathe easy and download videos on the fly to enjoy remote access
✅ 350+ Multiple Choice Based Tests to track your progress & evaluate your current level of proficiency with excel
✅ Interviews with Corporate Professionals from World’s Leading Organizations - uncover their experience with Excel & how they use Excel in their daily work to make real-time business decisions.
✅ Real-life use cases of excel that you can use in your job, business, or internship
✅ Certificate from Skill91 that you can highlight in your resume
✅ And above all a 24x7 Discussion Forum where you can ask all your doubts for an unlimited number of times and get personalized responses in a community of more than 3500 students who are learning excel with you RIGHT NOW!
Wondering about validity?
Don't worry. Each enrollment is valid for a SOLID 365 days!
No matter if you're a student, professional, or just looking to get started on MS-Excel
Excel Club will prove to be an EXCELLENT choice for mastering MS-Excel in a unique, fun, engaging, and informative way.
=========
Related Topics:
How to calculate difference in two dates in excel
How to calculate number of days between two dates in excel
How to calculate number of years between two dates in excel
How to calculate number of months between two dates in excel
Calculate years and months between two dates excel
Excel DATEDIF - calculate difference between two dates
Calculate Difference in Years, Months and Days between Two Dates
==========
Related Tags:
#ExcelForBeginners
#ExcelTutorial
#ExcelBasics
#ExcelDatedIf
#DatedIfFunction
#ExcelLectures
#DifferenceBetweenDates
==========
Related Videos:
Excel Lecture 1 | Excel for Beginners ( हिंदी ) | Excel Tutorials By CA Neeraj Arora- • Excel Lecture 1 | Exce...
Excel Smart Sum | Excel का ये Hack आपको बनाएगा ऑफिस में सबसे Smart | Neeraj Arora: • Excel Smart Sum | Exce...
Excel Goal Seek Function: • Excel Lecture 19 | Goa...
Find Blank Cells In Excel | Neeraj Arora: • Find Blank Cells In Ex...
Finding and Highlight In Excel | Excel For Beginners | Neeraj Arora: • Finding and Highlight ...
Excel Trick | Excel Smart Drag Down | Neeraj Arora: • Excel Trick | Excel Sm...
Excel Repeat Function | Magic Trick in Excel | Neeraj Arora: • Excel Repeat Function ...

[@ayushvyas925]

Nicee 👌

[@ambujkansal]

Thanks sir

[@aaquib...5390]

Its just too good....😍

[@RDesai-up6eh]

Thanks sir !

[@ivinitmittal]

👍🏻

[@vinayk4636]

226k subscribers hogye hai sirji 225k nahi. 😅

[@revatisuryavanshi1729]

Please video for payroll

[@aartisanghi3666]

Suppose ek table h jisme 1 to 10 likha h line wise like 1 2 3 4 5....10
Or dusri table m likha h 2, 10 ,11, 1, 3 5, 7 ,8,9,6 ( isi pattern me likha h )
To hum kaise pta krnge ki dono table m kon kon s common h and kon kon s alag h
Plz sir make a vedio on this
This will help a lot to us

[@MohitKumar-lg2vo]

You are using macro in this sheet for non 365 users.

[@AkashBhayani]

normal use =(b4-c4)

[@manoharprajapati1443]

Bro I have Excel 2016. But it doesn't have this DATEDIF function. I applied your =B4-C4 and calculated the difference between 31-03-2020 and 31-12-2019. But the answer is coming as 08-01-1900. Could you please tell me how to format the cells to get answer in Years, Months and Days like Sir calculated in this video?🙏