Date Range calculations of sub groups

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Custom1 = Table.TransformColumns(Source,{{"Start date",each Date.From(_,"en")},{"End date",each Date.From(_,"en")}}),
    Custom2 = #table(
                     Table.ColumnNames(Custom1)&{"Total Time (Years)","Time in Last Salary Band (Years)"},
                     List.TransformMany(
                                        Table.Group(
                                                    Custom1,
                                                    List.FirstN(Table.ColumnNames(Custom1),2),
                                                    {"n",
                                                     each List.Accumulate(
                                                                          Table.ToRows(_)&{{}},
                                                                          {},
                                                                          (x,y)=>if x={}
                                                                                 then {{},y,[]}
                                                                                 else if List.FirstN(x{1},3)=List.FirstN(y,3) and y{3}<=x{1}{4}+Duration.From(1)
                                                                                      then {x{0},List.FirstN(x{1},4)&{y{4}},x{2}}
                                                                                      else {x{0}&{x{1}},
                                                                                            y,
                                                                                            x{2}&Record.AddField(
                                                                                                                 [],
                                                                                                                 Text.From(x{1}{2}),
                                                                                                                 Record.FieldOrDefault(x{2},Text.From(x{1}{2}),0)+Duration.Days(List.Min({Date.From(DateTime.LocalNow()),x{1}{4}})-x{1}{3})/365
                                                                                                                )
                                                                                           }
                                                                         )
                                                    }
                                                   )[n],
                                        (x)=>List.Transform(x{0},each _&{Record.Field(x{2},Text.From(_{2})),Record.Field(x{2},Text.From(List.Last(x{0}){2}))}),
                                        (x,y)=>y
                                       )
                    )
in
    Custom2

Thanks Daniel!  I will test this out and let you know how it goes.

Thank you again!

J