excelisfun | Power Query Dates Are Better Than Excel Worksheet Dates! Excel Magic Trick 1825 @excelisfun | Uploaded 1 year ago | Updated 1 day ago
Download Excel File: https://excelisfun.net/files/EMT1825.xlsx
Learn about how Power Query Dates are different from Excel Worksheet Dates. Learn that dates in Power Query range from 1/1/0001 to 12/31/9999. Learn how to add and subtract dates in Power Query, Excel too.
Topics:
1. (00:00) Introduction
2. (00:16) Excel & Lotus 1-2-3 Dates have two problems. Power Query solved these problems.
3. (00:53) Date Serial Numbers are Different in Power Query.
4. (01:47) Date Data Type
5. (02:08) Extract Year from Date
6. (02:20) Subtract Two Dates using Duration.Days function.
7. (02:57) Add Days to a Date using Date.AddDays function
8. (03:36) Adding and Subtracting Dates in the Excel Worksheet
9. (04:12) Hard Coding Dates in the Excel Worksheet
10. (04:40) Hard Coding Dates in Power Query
11. (05:30) Using Dates before 1/1/1900 in Excel is Possible.
12. (05:48) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp

#date #dates #powerquerytutorial #dateeducation