Generating a list between 2 dates

[SCNCKS1]

I am attempting to generate a list of working dates between start and end dates. I am getting an error, but it doesn't give me a code, can someone please point me in the direction of my error?

= Table.AddColumn(#"Changed Type1", "Dates_Test", each let
StartDate = [DA_EXPECTED_START_DATE],
EndDate = [DA_EXPECTED_END_DATE],
WorkingDays = List.Dates(StartDate, Duration.From(EndDate - StartDate) + 1, #duration(1, 0, 0, 0)),
FilteredWorkingDays = List.Select(WorkingDays, each Date.DayOfWeek(_) <> 0 and Date.DayOfWeek(_) <> 6)
in
FilteredWorkingDays)

[Vijay_A_Verma · Accepted solution]

Change Duration.From to Duration.Days

Also you can replace Date.DayOfWeek(_) <> 0 and Date.DayOfWeek(_) <> 6) with Date.DayOfWeek(_,1)<5

Hence, your code will become

= Table.AddColumn(#"Changed Type1", "Dates_Test", each let
StartDate = [DA_EXPECTED_START_DATE],
EndDate = [DA_EXPECTED_END_DATE],
WorkingDays = List.Dates(StartDate, Duration.Days(EndDate - StartDate) + 1, #duration(1, 0, 0, 0)),
FilteredWorkingDays = List.Select(WorkingDays, each Date.DayOfWeek(_,1) < 5)
in
FilteredWorkingDays)