Excel DateDif function - difference between two dates
In Excel, if you need to calculate the difference between two dates in years, month, or days, the DATEDIF function will handle it. DATEDIF is "Date & Dif". It is an interesting function since it does not show up in the Date & Time function in Excel. 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, unit)
File download for DateDif - two worksheets
https://chrismenardtraining.com/Files...
Chapters:
0:00 Intro
0:45 DateDif - Year Y
2:36 DateDif - Month M
2:47 DateDif - Day D
3:45 DateDif - YM
4:37 DateDif - MD
5:00 absolute & relative
6:02 asbolute & mixed
7:35 important note about file
Unit Result
Screenshot with examples https://drive.google.com/file/d/1QyKF...
"y" Difference in complete years
"m" Difference in complete months
"d" Difference in days
"md" Difference in days, ignoring months and years
"ym" Difference in months, ignoring years
"yd" Difference in days, ignoring years
#msexcel #microsoftexcel #chrismenardtraining
Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios. Please see the known issues section of this article for further details.
Chris Menard's website: https://chrismenardtraining.com
Cristian's YouTube Channel: / @graphicious
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
En esta página del sitio puede ver el video en línea Excel DateDif function - difference between two dates de Duración hora minuto segunda en buena calidad , que subió el usuario Chris Menard 19 octubre 2020, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 26,050 veces y le gustó 172 a los espectadores. Disfruta viendo!
