Forum Discussion
Solved
How to get weekdays from a date range
Hi everyone I am new here and hoping someone can help me find a solution to this powerquery problem: Let's say I have two columns with dates in them, one called "startdate" and one called "enddat...
= List.Transform({Number.From([StartDate])..Number.From([EndDate)},each Date.DayOfWeekName(Date.From(_)))
Thank you very much indeed to both KeyurPatel14 and wdx223_Daniel for their kind assistance
wdx223_Daniel's solution was the best fit for what I am trying to do.
In case anyone else has a similar requirement and searches for this in the future, I needed to add one square bracket to wdx223_Daniel's solution for it to work (I have inserted it into his solution and made it red/bold):
= List.Transform({Number.From([StartDate])..Number.From([EndDate])},each Date.DayOfWeekName(Date.From(_)))