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.
power query
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 Split Date and Time
This step-by-step guide will walk you through the process of split your date and time data with Power Query.