Detailed Excel DATEDIF Function | =DATEDIF (start_date, end_date, "YD")

Publié le: 16 août 2022
sur la chaîne: EXCEL MADE EASY

719

Excel's DATEDIF function will calculate the number of years, months, or days between two dates.

This is a great function if you work in Human Resources (HR), or any job position where you need the difference in dates. I also use the TODAY function

00:05 Scenario 1 - DATEDIF with "D" The number of days in the period.
01:33 Scenario 2 - DATEDIF with "M" The number of complete months in the period.
02:20 Scenario 3 - DATEDIF with "Y" The number of complete years in the period.
03:00 Scenario 4 - DATEDIF with "YD" The difference between the days of start_date and end_date. The years of the dates are ignored.
03:49 Scenario 5 - DATEDIF with "MD" The difference between the days in start_date and end_date. The months and years of the dates are ignored.
04:24 Scenario 2 - DATEDIF with "YM" The difference between the months in start_date and end_date. The days and years of the dates are ignored
05:33 Recap
06:09 Watch next video

Syntax for DATEDIF:
DATEDIF(start_date,end_date,unit)
Example: DATEDIF(A2,B2,"Y")

Units:
"Y" The number of complete years in the period.
"M" The number of complete months in the period.
"D" The number of days in the period.
"MD" The difference between the days in start_date and end_date. The months and years of the dates are ignored.
"YM" The difference between the months in start_date and end_date. The days and years of the dates are ignored
"YD" The difference between the days of start_date and end_date. The years of the dates are ignored.

DATEDIF has three arguments - start date, end date, and date unit (year/month/ or date).

Reason to use DATEDIF
Get days, months, or years between two dates
HR could use this to see how long employees have worked. We could track how long customers have been in the system.

Syntax
=DATEDIF (start_date, end_date, "YD")

===POWER PACK ===
Join over 500 + professionals that Have gone from Zero-to-Hero in our Excel course: https://bit.ly/3vIQOpB
__________
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://paypal.me/touchinglivesent?co...

Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!

How to Change Date Format in Excel, Format a date, Change the default Date format in Excel, Change date format in Excel, Excel date format, How to convert date in Excel, Formatting Dates in Excel, Change format of date in Excel, How to quickly convert date format between European and US, How to quickly convert US date format to European date in Excel, Converting dates from US format in Excel,Excel video tutorial, Microsoft Excel, onuzurike chukwuagozie, microsoft excel, DATEDIF Function, excel datedif function, HR excel, Excel for HR, Excel datedif formula, excel tips, excel formulas, Excel DATEDIF | Excel One Minute Quick Reference, excel tips and tricks, excel 2016, excel 2013, excel 2019, excel tutorial, microsoft 365, learn excel, Excel one minute video, excel short video, excel one video tutorial, Excel DATEDIF Function

excel data forms, excel data entry forms, creating data entry forms, creating excel data entry forms, how to create excel forms, how to create excel data entry forms, exel data entry forms, ecxel forms, doing excel data entry, exel data entry, excel data entry, creating excel entry forms for dummies, creating excel forms, data entry in excel, data entry in exel

EXCEL made easy, Excel Tutorials, Leila Gharani, Excel 2016, Excel 2013, Excel 2010, Advanced Excel tricks, Excel online course, Excel tips and tricks, Excel for analysts, how to create data entry form in excel, data entry from without vba, data entry, excel data entry form, excel data entry form with data validation, excel data entry form for table, excel data entry form button, excel hidden features, excel hidden tips

Sur cette page du site, vous pouvez voir la vidéo en ligne Detailed Excel DATEDIF Function | =DATEDIF (start_date, end_date, "YD") durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur EXCEL MADE EASY 16 août 2022, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 719 fois et il a aimé 2 téléspectateurs. Bon visionnage!

9,539

401