DATEDIFF for POWER QUERY
This article gives you the M Code for Power Query to return the result of the DATEDIFF function (difference between 2 dates)
Power Query
Learn how to manipulate and transform your data effortlessly with Power Query. Find examples and tips to optimize your data analysis process.
Merge Multiple Excel files into one workbook
How to merge many Excel workbooks into a single one? This steby-step guide will explain you the technique with Excel and Power Query.
Extract folder and subfolders with Excel
It's very easy to extract the hierarchy of a folder and subfolders with Excel. In just 5 steps the job is done.
Excel Split Date and Time
Discover how to separate date and time in Excel with ease. Use the INT and subtraction functions to extract the desired values.
Categories
- Conditional (12)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (15)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (19)
- Lookup functions (14)
- Manage data (19)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (4)
- Shortcuts (5)
- Statistical functions (25)
- Text functions (17)
- Tips and Tricks (21)
