(Date1 as date , Date2 as date) =>
let
Source =
List.Generate(
() => [x = 1, y = Date.AddMonths(Date1,x)],
each [y] <= Date2,
each [x = [x] + 1, y = Date.AddMonths(Date1,x)],
each [y]
),
Months = List.Count(Source)
in
Months
something?
(Date1 as date , Date2 as date) =>
Something in between
let
Source = Excel.Workbook(File.Contents("C:\Example.xlsx"), null, true)
in
Source