To find the difference between two dates, you can subtract the older date from the newer one. That will return the difference in days; however, you might want it in weeks, months, or years. The little-known DATEDIF function is the perfect solution for this. You won't see any mention of it in Excel, as it's undocumented. However, its versatility prevents the need to construct long, windy formulas to achieve the same result, and therefore worth considering. Just make sure you use it responsibly… �
To find the difference between two dates, you can subtract the older date from the newer one. That will return the difference in days; however, you might want it in weeks, months, or years. The little-known DATEDIF function is the perfect solution for this. You won't see any mention of it in Excel, as it's undocumented. However, its versatility prevents the need to construct long, windy formulas to achieve the same result, and therefore worth considering. Just make sure you use it responsibly… �
32.4K viewsMay 5, 2023
TikTokglobalexcelsummit
Excel DATEDIF function
6:35
Excel DATEDIF function
28.1K viewsFeb 16, 2016
YouTubeSteve Chase
Excel Weekday Function
5:58
Excel Weekday Function
279.7K viewsDec 24, 2017
YouTubeSyed Shah Zahurullah Hussaini
Excel DATEDIF Function (Between Two Dates)
4:13
Excel DATEDIF Function (Between Two Dates)
97.4K viewsMar 18, 2021
YouTubeExcel Superstar
How to Enable Weeks in Power BI
5:09
How to Enable Weeks in Power BI
51.3K viewsJul 7, 2020
YouTubePower BI Playbook
57. DATEDIFF Function in SQL
9:23
57. DATEDIFF Function in SQL
25K viewsJul 19, 2020
YouTubeAlex Shafe - Databoard Analytics
Excel 2019/365: Date Functions: DATEDIF
4:13
Excel 2019/365: Date Functions: DATEDIF
18.2K viewsAug 8, 2019
YouTubeTom Kleen
21:29
DatePart, DateAdd and DateDiff functions in SQL Server Part 27
337K viewsSep 1, 2012
YouTubekudvenkat
17:47
Power Apps Date Calculations for Business Days
49.6K viewsJul 8, 2020
YouTubeReza Dorrani
9:26
How to Create Date Difference in SharePoint List Using Calculated Column
42.8K viewsMay 31, 2021
YouTubeTheOyinbooke
14:57
Calculating Workdays Between Two Dates In Power BI
33K viewsJun 21, 2020
YouTubeEnterprise DNA
9:38
Excel DateDif function - difference between two dates
26.1K viewsOct 19, 2020
YouTubeChris Menard
13:41
How to Properly Calculate Age from Date of Birth in Microsoft Access and Excel. Don't Use DateDiff!
61.8K viewsNov 16, 2020
YouTubeComputer Learning Zone
2:08
Learn SQL: Query 11: BETWEEN two DATES
44.9K viewsMay 25, 2017
YouTubeMark Keith
6:34
Microsoft Excel Calculate the Difference Between Two Dates and DATEDIF Function
22.3K viewsSep 18, 2012
YouTubeComputer Learning Zone
9:20
Microsoft Access Number of Days Between Two Dates - DATEDIFF Function - Date Difference - TechHelp
43.3K viewsMar 31, 2020
YouTubeComputer Learning Zone
1:28
Calculate Total Weeks Between Two Dates - Excel 2013
46.6K viewsNov 14, 2016
YouTubeExcel Destination
34:28
Power Apps Date Time Math - Do calculations for payroll and timesheets
36.3K viewsJan 18, 2021
YouTubeShane Young
1:10
How to calculate the difference in dates with one date field in Tableau
46.9K viewsAug 22, 2018
YouTubeTableau
2:13
Excel: Calculate Number of Weeks between two dates
24.5K viewsOct 5, 2014
YouTubeTecAngel
1:22
How to Calculate date differences and determine the day of the week in Excel
21.1K viewsNov 23, 2012
YouTubeExcel, Word and PowerPoint Tutorials from Ho…
10:20
Use the DateAdd Function in Microsoft Access to Add or Subtract Whole Calendar Months, Years, Hours
23.7K viewsNov 18, 2020
YouTubeComputer Learning Zone
8:09
Number of Days Between Two Dates - DATEDIFF Function - Microsoft Access - Query - Calculated Fields
9.2K viewsJun 12, 2020
YouTubeThe Online Learning Space
15:28
SQL Query | Calculate number of weekdays between two dates | Exclude Weekends | DateDiff | DateName
57.4K viewsSep 8, 2020
YouTubeLearn at Knowstar
14:36
Number of working days between two date fields in Tableau | Calculate business days in Tableau
6.1K viewsDec 30, 2020
YouTubeTableau Tutor
3:44
PowerBI: Calculate business/working days between two dates in a new column
35.5K viewsApr 20, 2019
YouTubeGraciela @ Power GI
2:04
Comment Calculer la Différence Entre Deux Dates dans Excel ? Fonction DATEDIF
16.4K viewsOct 26, 2020
YouTubeNumelion IT
5:38
Comment calculer la différence entre deux dates avec la formule DATEDIF sur EXCEL
9.3K viewsAug 12, 2019
YouTubeExcel Formation
5:38
SQL DATEDIFF Function Explained
5.2K viewsMay 29, 2023
YouTubeRyan & Matt Data Science
7:43
MS Project DateDiff function
3.7K viewsMay 7, 2022
YouTubeKarl Ernst Buddenbrock
See more