title: Show all dates between two dates in M language excel
body: <p>I'm doing a date dimension based workbook on Excel and I'm stuck at creating a new table for showing all days between two dates that lie in my workbook's cells <code>B2:Bx</code> and <code>C2:Cx</code>. In the M-language editor I'm trying to create a new column for showing the days in format 1.1.2018. It could probably be done with functions like <code>=DAYS(YEAR(B2:Cx))</code> but I'm trying to figure out a way in PowerQuery. So I need <code>B</code> and <code>C</code> columns as a reference and all dates in between the first date in <code>B</code> and last date in <code>C</code>.</p>